Probably using a Crosstab? Try using the query wizard, and see what you can
get out of it.
Doing so you un-normalize your data. Easier to look at, for human reading,
but harder to work with, for the computer. So, do not DELETE the already
normalized tables, they are probably more useful as they are. And for human
reading, well, use forms/reports based on the CROSSTAB QUERY you will
create.
Sure, these remarks are general and may not be applicable in YOUR specific
case, though.
Vanderghast, Access MVP
