I have a report that has different groupings by REASON CODE. The reason codes are stored as two digits, i.e. RA represents "Radio Ad." I would like the section headings in my report to show up as with the representative titles instead of the two digit representations. I am not sure how to accomplish this in a report. I know that I can't use a Case Loop, and the Iff statement is too simple because I have 15 reason codes. Maybe a nested Iff is possible?????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Representation in a report
- Thread starter MinnKota
- Start date
Your best bet would be to add the table with the descriptions to the query that serves as the reports record source, and include the description field in the query. Then the field would be available in the report.
You could also have a look at the DLookup() function, but this is slower and less efficient then including the field in the query.
-Gary
You could also have a look at the DLookup() function, but this is slower and less efficient then including the field in the query.
-Gary
- Thread starter
- #3
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
