Do you have a table somewhere that lists
20 Lamp
30 Desk
40 Chair

If so, in your query, add that table, and join on the PRODUCT_ID. Then,
instead of showing PRODUCT_ID, select the field from the (lookup) table that
has "Lamp", "Desk", "...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"la knight" wrote in message
news
Jeff:

Thanks for all your help. I did take your advice by starting with a blank
query and building it up piece by piece until I was returned the results I
was looking for. I guess the best advice I can give other new users would
be
to do it this way also. It did take some trial and error to get the
columns
of queries in the correct order, totaled, group and sorted to achieve my
results, but once I did - it was a beautiful thing!

One other question if your still listening - Is there a way to change the
display text of a query result to read as something else? Meaning this:

If I query a "PRODUCT_ID" which has a value of "20", can I change the
display of the result in the field to read as "lamp" instead of "20"?

Hope that makes sense. I've looked for an answer for this one too, but I'm
not sure I'm using the correct terminology to find the answer.