Counting and Unique values

[zozew]

Hi, I get this result:

from this SQL string:

SELECT tblInmateCases.BR
FROM tblInmatesProfile INNER JOIN (tblInmateCases INNER JOIN tblInmateHearings ON tblInmateCases.CaseNumberID = tblInmateHearings.CaseNumberID) ON tblInmatesProfile.InmateID = tblInmateCases.InmateID
WHERE (((tblInmateHearings.Hearings)=[Forms]![scheduleChooserForm]![dateForSchedule]));

How would i get a new result with only the unique BR values in one field and in the second field a total of records for each BR value.

So how would i go about to change the SQL to get this instead:

BR, Total
14, 4
16, 4
18, 3
20, 7


Do i need to break it up in different queries somehow?

thx for any suggestions

 

[John Big Booty]

Have a look at a Totals query, and use the Group By option.

 

[zozew]

Have a look at a Totals query, and use the Group By option.

Well that was that, thanks and i'm amazed at how basic some problems seem when you have solved them.

Thank you immensely!

 

[John Big Booty]

Glad to have been able to help