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?