Query Question

[Guest]

Hi,

I have a query that identifies a building contractor and how many snagging
items that contractor has per quarter. Each snagging item has a worktype, i
want to specify 4 worktypes to look for (there are a large variety of
worktypes) under a specific building contractor. When I run the query Access
breaks down each worktype and counts the number of snagging items. I need the
query simply to add all these snagging items together, so I have four lines
to my query output, giving me the total snagging items that fall under the
four worktypes per quarter. I've tried using 'And' instead of 'Or' when
setting the criteria in my worktype column, but it does not work.

Any help would be great.

Cheers,

Phil

 

[[MVP] S.Clark]

You can do this easily on a report, or...
You can do it the hard way with a 2nd query that performs grand total, then
UNION it to the first query.