concatenate in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
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.
 
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!
 
Back
Top