Access Reports and Concatenation

[cmrobinson]

All,
I have a strange little problem that I am sure there is an answer for. I am trying to do a simple concatenation on a Report (just like I would do it on a form or query) and it will not work.

Basically I am trying to concatenate a Firstname and Lastname field from a members table. This is what I've got for the Control Source of the text box:
=tblMembers![Last Name] & ", " & tblMembers!First

When I view the report it wants me to enter a Parameter Value for the tblMembers. This works fine on forms and queries...?

Any ideas?

Thanks!
Carrie

 

[SuicidED]

If the reports based on the table tblMembers then the conrol source should be =[Last Name]&", "&[First].