• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • Last Modified:

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
0
brendanlefavre
Asked:
brendanlefavre
  • 2
1 Solution
 
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
 
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now