Query criteria question

[sdzc]

I have a query that I have to run using two different sets of numbers in order to get the results I need. The problem is that these numbers do not mean much when the query is run and we see the result. I would rather have them see a word which represents the two numbers. Is this possible?

For example:
Field1 Field2
72 7
72 10
72 4

I am grouping by these numbers and they show up on the query result. I would like to have something else show up in the result other than what shows in Field2 above yet still have the query be accurate as if it was based on the 7, 10 and 4.

This is what I would like to see:
Field1 Field2
72 Red
72 White
72 Blue

Or is it possible to add another column into the query design that just shows the names I want to show without it hindering the query, but yet it still shows the Red, White, Blue labels?

Thanks for any help!

 

[neileg]

I presume you have a table that matches the colours to their corresponding numbers. Include the colour field in your query. Leave the sorting and grouping based on the number field, and clear the check box on the 'Show' line for this field.