Concatenation In Detail Section of Report

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I am trying to concatenate several fields (name, addr,
city, etc) in the detail section of a report using the
ampersand. I keep getting an error message that
states "Microsoft cannot find the field [field name1]&" "&
[field name2] referred to in your expression."

I can do this in the header section. Am I doing
something wrong?
 
I did try this but got the same error message.
-----Original Message-----
Are you preceding your expression with "="?

--
Duane Hookom
MS Access MVP


I am trying to concatenate several fields (name, addr,
city, etc) in the detail section of a report using the
ampersand. I keep getting an error message that
states "Microsoft cannot find the field [field name1] &" "&
[field name2] referred to in your expression."

I can do this in the header section. Am I doing
something wrong?
Click to expand...


.
Click to expand...
 
Would you post the expression exactly as you have it
entered along with the NAME of the textbox the expression
is located in?

Thanks
 
Back
Top