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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW CAN I COUNT ALL THE GROUPS IN A REPORT 1
Dynamic Group Report 2
Display Option Group label name versus value 2
Converting Option Group values to text in a report 2
Option group to display on a report 2
report options box text values 3
How do I make option box values (1,2,3) display as text in report 1
Change text box background color depending on value in Label Reports 1

Back
Top