Help with query criteria

[batowl]

This strikes me as an easy problem that I cannot seem to solve on my own.



I have a query where I want all the results for a given field returned. But I also want to show results in this query for results of this same field based on certain criteria. (Each of these query fields is actually filled with an expression where if the answer to the field is "Yes", the field gets a 1, if not it gets a 0. So what I am trying to achieve is a total count of all the orders in a given year and also a count of all the orders in that year that meet this certain criteria). I have this set up as two fields, Orders1 and Orders2. In separate queries each of these works just fine, but I cannot place them both in the same query (I get the same number for each field) and I cannot leave them as separate queries then combine the responses in a report (report will not do that). Any suggestions? Thank you.

[June7]

Build a report.

You can probably use report grouping & sorting features with aggregate calcs in group and report header/footer sections to display totals. Can even have a calc that is conditional on some value.

Base the report RecordSource on the raw query (no summation) then do calcs in header/footer sections.