Count Expression

[Guest]

I have a query that selects all patients that were initially Triaged for
Admit. I have a second column in the query that lists what actually happened
to them and include three values from a table. Is there an expressions that
I can use to count the number of times that each different value appears in
the column
autSortCategoryID strSortCategory CountOfautSortCategoryID dtmAuditDate strDispositionCategory
3 1 Discharge 1 05/30/2006 Discharged
5 1 Discharge 1 05/30/2006 Admitted
6 1 Discharge 1 06/01/2006 Admitted
7 1 Discharge 1 06/04/2006 Walk Out
8 1 Discharge 1 06/03/2006 Admitted
10 1 Discharge 1 06/06/2006 Discharged

 

[Guest]

Depending on if you want this in report form or in form view or data sheet.
Tell me which it is your looking for I can tell you how. Are you entering
and viewing this information from a form? or in datasheet view? You can email
me direct if you like. See my profile