Microsoft Access - Report - adding more information to one field

Posted on 2014-07-10
Last Modified: 2014-07-16
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
From ELITETimeKeeper.

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?
Question by:anglandp
    1 Comment
    LVL 30

    Accepted Solution

    In a report, just use text boxes to display the required fields for the record.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now