Display field name

[KarenS]

Hi,

I have a field in my query that displays the occupation of an employee. I have another field with an "if" expression, which displays the occupation if certain criteria is met. However, it displays the occupation ID and not the name.

The occupation ID is an autonumber, but I just want to see the name.

Is there an easy way to do this

 

[Sergeant]

Yes, add the related table to your query and select the occupation field from that table instead of the occupationID field.