Bound Column - Need to show show other column on report

[Tiredmom]

I am working on a database that uses a lookup field called Job Family that contains two pieces of information, a category number and a descriptor. Ex: 1 = Executive, 2 = Director, 3 = Supervisor, etc. There are only a dozen entries altogether. I use the first column (the category) for sorting and filtering and this works fine. I only need the data in the second column on one report but can't seem to do this. Only the first bound column appears.

Could someone give me a bit of advice?

 

[dhookom]

If the lookup comes from a table (good idea) then include the table in the report's record source. If there is not a table, then try:
=Choose([JobFamily], "Executive", "Director", "Supervisor")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.