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.

your calculation should look like this.

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

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

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, 200718 yr by Guest

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

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:

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

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

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

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!

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

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

I thought you Aussies say, corn-kate-Mate

lol. :

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

As for you John! LOL!

con-cut-an-eight -- Kiwi?

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

con-cut-an-eight -- Kiwi?

Or... Norfolk UK??

--sd

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.

cnktN8 if you want to txt it :

Is there a tax on vowels?

Nah, I think Stuart was making a license plate.

I suspect vowel play

I think Stuart was making a license plate.

Ah. So that new avatar is actually a mugshot?

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

The picture is becoming clear...

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.

haha That's classic :)