Combine words

[selfstorage]

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.

[grumbachr]

your calculation should look like this.

"field 1" & " " & "field 2" & " " & "field 3".

[selfstorage]

thanks you very much.....i have spent all day on trying to figure it out......i really appreciated it!

[LaRetta]

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

[Vaughan]

Or as we say in Australia, corn-kate-nate. :

[LaRetta]

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:

[Genx]

lol I personally have a bad habit of saying con-cact-inate for some reason.

[Stuart Taylor]

I didn't realize it had a name and now i have no idea how to say it in my native tongue? :

[Genx]

It really is: con-CATTIN-nate as LaRetta says.. doesn't mean i have to like it lol.

[Stuart Taylor]

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!

[comment]

I believe it should sound like "con-cut-an-eight" - or "con-cotton-ate"

[mr_vodka]

Or as we say in Australia, corn-kate-nate. :

I thought you Aussies say, corn-kate-Mate

lol. :

[Genx]

con-cut-an-eight ... that must be american, i've never heard anyone say it like that before.

As for you John! LOL!

[Vaughan]

con-cut-an-eight -- Kiwi?

[Genx]

Doubt it, kiwis only really pronounce i's and e's funny.

[Søren Dyhr]

con-cut-an-eight -- Kiwi?

Or... Norfolk UK??

--sd

[comment]

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.

[Stuart Taylor]

cnktN8 if you want to txt it :

[comment]

Is there a tax on vowels?

[LaRetta]

Nah, I think Stuart was making a license plate.

[Stuart Taylor]

I suspect vowel play

[comment]

I think Stuart was making a license plate.

Ah. So that new avatar is actually a mugshot?

[LaRetta]

Most certainly! Did you see those shifty eyes? And he most certainly looks guilty about SOMETHING! Vowel play for sure! :jester:

[comment]

The picture is becoming clear...

[Stuart Taylor]

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.

[AudioFreak]

haha That's classic :)