Showing Value of Option Group in Reports

  • Thread starter Thread starter SBoyd
  • Start date Start date
S

SBoyd

I am using a form with an option box that gives 3
different choices of a job status; Bidding, Active,
Unawarded. The table stores this data as 1, 2, and 3
according to the choice. In a report, how do i show the
VALUE of 1, 2, or 3 instead of just the number?
 
Create a small lookup table with three records
tblJobStatus
StatusID numeric values of 1, 2, 3
StatusTitle text values of Bidding, Active, Unawarded

Include this table in your report's record source and join the StatusID
field to your current field. Add the StatusTitle field to the report's
record source.
 
Back
Top