Microsoft Access - Report - adding more information to one field
Posted on 2014-07-10
I have a report that was auto-generated with Access. One of my fields contains a timekeeper ID. However, the table that holds that info also has a first name and a last name field as well. When looking at the Row Source for this combo box in the report, I have the following query
Select ELITETimekeeper.ID, ELITETimekeeper.TimeKeeper, ELITETimeKeeper,Lastname, ELITETimeKeeper.Firstname
The Report shows the ELITETimekeeper.TimeKeeper field, which is just a time keeper number.
I'd love for it to show the last name and first name as well, but I cannot figure out how to do it in the Report. I have it working in the Form, by modifying the Column Count and column width properties, but this does not seem to be working with the Report.
Can anyone help?