Text rather than value

[Mac_Wood]

Hi,

I have a report based on a table which contains two combos. In the table both combos display text rather than a value but when I created a report one displays text and the other a value. The one that displays a value I have used to group the rest of the records by. What am I doing wrong please?

 

[Mac_Wood]

Thanks Pat for your suggestions.

I joined the two tables in a query and hey presto it worked perfectly.

Thanks again.