Access 2010 Report - Display Value from Query

Posted on 2011-10-19
Last Modified: 2012-06-07
I have an access 2010 web database that i'm trying to create a report on. The query for the report returns all of the expected values, but when binding a text box on the report it shows the ID value of a look-up field instead of the desired value.

the field is Day Of Week, it's value comes from a look-up field to a table named tblDayOfWeek

the table the look-up field is on is tblReading

Is there a way to specify which values are displayed from a look-up field?


 report - design viewreport-2.png
Question by:brendanlefavre
    LVL 119

    Expert Comment

    by:Rey Obrero
    you need to change the Record Source of the report with a query of the table with a join on the ID field of lookup table. Include the [Day Of Week] field in your query.
    LVL 119

    Accepted Solution

    the query is something like this

    Select tblReading.* ,tblDayOfWeek.[Day Of Week]
    From tblReading Inner join tblDayOfWeek ON

    Featured Post

    Too many email signature changes to deal with?

    Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

    Join & Write a Comment

    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013…

    729 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