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.