Jump to content
Sign in to follow this  
selfstorage

Combine words

Recommended Posts

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.

Share this post


Link to post
Share on other sites

your calculation should look like this.

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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! :wink2:

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). :smirk:

LaRetta

Edited by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

I thought you Aussies say, corn-kate-Mate

lol. :

Share this post


Link to post
Share on other sites

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

As for you John! LOL!

Share this post


Link to post
Share on other sites

con-cut-an-eight -- Kiwi?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Nah, I think Stuart was making a license plate.

Share this post


Link to post
Share on other sites

I think Stuart was making a license plate.

Ah. So that new avatar is actually a mugshot?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

images-2.jpg

images-1.jpg

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.