THanks for the info - I'll get a better structure put together.

Th very basics of this was only shown - The "returns" tables actualyl consists of much more, but I have a view that consolidates it into the basic details I need to see.

Waht we are looking for in the end is to do a monthly report showing the products that COULD have been returned (differnet receivers, with different types of returns based on the customer type).

A generic cross-tab would typically be sufficient, however, based ont eh nature of the report, they want to know for a fact that we did NOT get a product/manufacturer in by showing the value as a 0 count.

(seems a bit backwards to me - wold be easier to do a cross-tab and then direct export it to a master Excel file with vlookups, but this is not what they bosses want to do.

As stated, I'll put together the stures as we are dealing with it and some raw data to give a better idea of what we are needing to see (and yes, I know the details I posted here are differnet from the display I was showing, but it's the same concept - just different "categories").