Two Different "Group By"'s in the Same Query

[Lady_Jane]

Hi everyone,


I have two tables linked in a one to many relationship through ID field.
The first table has fields ID and Type
The second table has fields ID, Region, and Percent
One ID in the first table can have many Regions in the second table.

I would like to produce a table that returns the total number of IDs per region where Percent >= 90 AND the total number of IDs per region where Percent is >=90 AND where Type is "Reference".

The final table would be have fields: Region, Total#ID, and #ReferenceID

Is it possible to do this in ONE query?

[ajetrumpet]

I think so.

What you have started on?? do you have a start on it??

[Lady_Jane]

I have written two other queries, one gets # ID's per region and the other gets # reference ID's per region. These combined with the second table (id, region, percent) produce the results I need. But I don't know how to do it without using the two other queries.

[ajetrumpet]

if that's important, than you're done!

there's nothing wrong with using two queries.