Access 2010 Report - Display Value from Query

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?

Cheers,
Brendan

 report - design viewreport-2.png
report-3.png
report-4.png
brendanlefavreAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
the query is something like this

Select tblReading.* ,tblDayOfWeek.[Day Of Week]
From tblReading Inner join tblDayOfWeek ON
tblReading.DayOfWeek=tblDayOfWeek.ID
0
 
Rey Obrero (Capricorn1)Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.