Jump to content

This topic is 6162 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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
Link to comment
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:

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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