If you ever have to do more than one or two queries to extract the required data something's seriously wrong with your table structure.

Run the query that J provided and see if that works. If it doesn't, describe your table structure in detail, preferably with a diagram and example record, and example of the result you want from the query.