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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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