Value count (1 Viewer)

[RACHNA]

I have some a combo box named status with the following values

Status:
Accepted
Rejected
Incomplete
Deflected
Wthdrawn

In a report how can I show how can I show the number of times each value is chosen?

i.e Show how many times "Accepted" is chosen?

Thanks!!

 

[Pat Hartman]

Use the following query:
Select Status, Count(*) As Count
From YourTable
Group By Status;

This will produce the following recordset:

Status ---- Count
Accepted --- 503
Rejected --- 89
Incomplete - 46
Deflected -- 7
Wthdrawn --- 15