Trouble with expression builder 1

[Jedi420]

Im trying to use the expression builder to have a text box display several fields from the query that my report is based on. For instance I have a query that pulls up Name, Job, and SSN. I want to use the expression builder to concatenate these fields into one text box.
I've never used the expression builder before. Everything I try seems to produce an error in the text field where I want my data to show. Like, what selections do I make in those 3 columns to actually get to my data? I hope I explained that well enough. Thanks for your help. I really appreciate it. (^_^)

-Jedi420

 

[CosmoKramer]

I wouldn't use the expression builder. Just type it in the control source box. something like this:

=[Name] & " " & [Job] & " " & [SSN]

or whatever field seperators you would like.....

 

[Jedi420]

Thanks for responding .... whenever I put

=[Name]

in the control source, it shows

 #error

on the report. Any ideas?

-Jedi420

 

[CosmoKramer]

Is [Name] really the Name of that field??

 

[Jedi420]

Yes, it works without brackets, but when you add brakets, it shows '#error' in the report. And using

Name & " " & Job & " " & SSN

without brackets produces an error as well.

-Jedi420

 

[CosmoKramer]

Are you starting the statement with an equal sign??

=

[Name] & " " & [Job] & " " & [SSN]

 

[Jedi420]

Hey, I dont know what I was doing wrong, because I swear I was doing this yesterday and it didnt work (I'm sure it was something I was doing wrong), but using the

=[Name] & " " & [Job] & " " & [SSN]

format now works! Thanks a bunch for your help and patience! (^_^)

-Jedi420

 

[Chavito21]

Judi,

I found using Trim work pretty good.
Try using =Trim([Name] & " " & [Job] & " " & [SSN])
It take all the blank spaces out.

Good luck.