Thank you for your response Jay,

>Another distinction helpful is whether information is viewed on a data entry form/reported. In many cases, when reporting, normalization doesn't impose a noticeable performance penalty while it might in an interactive presentation. Also see below.

Ours are not batch reports, although we probably should have those too. The user asks for a report and immediately prints it, so speed is important.

>An intermediate table, which resolves the various categories into their respective summary categories may be a solution here.

Yes, that would solve the problem of gathering in one record the summary data. A good way to accomplish that would be to do an initial select which filters the data and then have a standard routine or two that summarize that into the intermediate table. Good idea.

Thank you.

Alex