concatenate in a report

K

KimG

Hi...I have a table that stores an employee id number, first and last names.
I built a query that concatenates the first and last names and eliminates the
id number, but when I run the report off the query, the id number is all that
shows. What am I doing wrong? Thanks!
 
D

Duane Hookom

Are you using lookup fields?
What is the sql view of your report's record source?
Do you see you concatenated field in the report's field list?
 
K

KimG

Yes, the employee field in the query is based on a table that uses a look up
field to find the list of employees

The sql appears to be just the name of the query

And finally, yes I do see the concatenated field in the field list. It's
the field that is displaying just the employee ID number instead of the name.
 
K

KimG

I kept fiddling and got it to work. I deleted the employee name text box and
re-added it using the field employee name in the field list, and now it
works...thanks!
 
Top