Unable to display values under groups in Access Reports

[ruizk]

I have three groupings in one of my reports, but I can't get the field to display the text value, it only shows the key. Is there something I'm missing? Thanks.

 

[misscrf]

what do you mean the "key" and not the text value. What is the field that you have in the group that is not showing right? in the underlying query, what does that field's data show?

misscrf

Management is doing things right, leadership is doing the right things

 

[dhookom]

I expect you need to add the "lookup" table to the report's record source so that you can display the "text value" field.

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