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!!

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