Newbies selfstorage Posted May 14, 2007 Newbies Share Posted May 14, 2007 Please help! I have 3 fields with words that i need to add together into 1 field. I made a calculation with "field 1" & "field 2" & "field 3". This works to combine the words BUT they do not have a space between the words. Can anyone tell me how to put a space between the words so they won't run together. Link to comment Share on other sites More sharing options...
grumbachr Posted May 14, 2007 Share Posted May 14, 2007 your calculation should look like this. "field 1" & " " & "field 2" & " " & "field 3". Link to comment Share on other sites More sharing options...
Newbies selfstorage Posted May 14, 2007 Author Newbies Share Posted May 14, 2007 thanks you very much.....i have spent all day on trying to figure it out......i really appreciated it! Link to comment Share on other sites More sharing options...
LaRetta Posted May 14, 2007 Share Posted May 14, 2007 (edited) Ummm, actually, you don't put quotes around field names - only literal text. So it would be: field 1 & " " & field 2 & " " & field 3 You were very close though! Another example - text of first name followed by the data of the FirstName field would be: "First Name: " & FirstName These types of calculations are called concatenate (pronounced con-CATTIN-nate). LaRetta Edited May 14, 2007 by Guest Link to comment Share on other sites More sharing options...
Vaughan Posted May 14, 2007 Share Posted May 14, 2007 Or as we say in Australia, corn-kate-nate. : Link to comment Share on other sites More sharing options...
LaRetta Posted May 14, 2007 Share Posted May 14, 2007 Ha ha! In Oregon, we pronounced it Consa-tin-ate! Of course, I'm the ONLY person I've ever heard pronouce it (until recently). Ha ha! You say tomahhhto and I'll say tomaaato! :beertime: Link to comment Share on other sites More sharing options...
Genx Posted May 15, 2007 Share Posted May 15, 2007 lol I personally have a bad habit of saying con-cact-inate for some reason. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted May 15, 2007 Share Posted May 15, 2007 I didn't realize it had a name and now i have no idea how to say it in my native tongue? : Link to comment Share on other sites More sharing options...
Genx Posted May 15, 2007 Share Posted May 15, 2007 It really is: con-CATTIN-nate as LaRetta says.. doesn't mean i have to like it lol. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted May 15, 2007 Share Posted May 15, 2007 Thanx Genx, good to clear that up, LOL LaRetta I say tomahhhto, although my neighbours say tomaaato. hehe An Englishman in New York as the song goes! Link to comment Share on other sites More sharing options...
comment Posted May 15, 2007 Share Posted May 15, 2007 I believe it should sound like "con-cut-an-eight" - or "con-cotton-ate" Link to comment Share on other sites More sharing options...
mr_vodka Posted May 15, 2007 Share Posted May 15, 2007 Or as we say in Australia, corn-kate-nate. : I thought you Aussies say, corn-kate-Mate lol. : Link to comment Share on other sites More sharing options...
Genx Posted May 16, 2007 Share Posted May 16, 2007 con-cut-an-eight ... that must be american, i've never heard anyone say it like that before. As for you John! LOL! Link to comment Share on other sites More sharing options...
Vaughan Posted May 16, 2007 Share Posted May 16, 2007 con-cut-an-eight -- Kiwi? Link to comment Share on other sites More sharing options...
Genx Posted May 16, 2007 Share Posted May 16, 2007 Doubt it, kiwis only really pronounce i's and e's funny. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 16, 2007 Share Posted May 16, 2007 con-cut-an-eight -- Kiwi? Or... Norfolk UK?? --sd Link to comment Share on other sites More sharing options...
comment Posted May 16, 2007 Share Posted May 16, 2007 I was only trying to translate this kön-kat'nāte into something readable (aloud). I don't think there was much opportunity to develop local pronunciations for this word. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted May 16, 2007 Share Posted May 16, 2007 cnktN8 if you want to txt it : Link to comment Share on other sites More sharing options...
comment Posted May 16, 2007 Share Posted May 16, 2007 Is there a tax on vowels? Link to comment Share on other sites More sharing options...
LaRetta Posted May 16, 2007 Share Posted May 16, 2007 Nah, I think Stuart was making a license plate. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted May 16, 2007 Share Posted May 16, 2007 I suspect vowel play Link to comment Share on other sites More sharing options...
comment Posted May 16, 2007 Share Posted May 16, 2007 I think Stuart was making a license plate. Ah. So that new avatar is actually a mugshot? Link to comment Share on other sites More sharing options...
LaRetta Posted May 16, 2007 Share Posted May 16, 2007 Most certainly! Did you see those shifty eyes? And he most certainly looks guilty about SOMETHING! Vowel play for sure! :jester: Link to comment Share on other sites More sharing options...
comment Posted May 16, 2007 Share Posted May 16, 2007 The picture is becoming clear... Link to comment Share on other sites More sharing options...
Stuart Taylor Posted May 16, 2007 Share Posted May 16, 2007 LMAO, I hope that doesn't get cache'd by google my visa's being processed at the moment. Oh well i'm in good company. Link to comment Share on other sites More sharing options...
AudioFreak Posted May 16, 2007 Share Posted May 16, 2007 haha That's classic :) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6162 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now