Simple distinct count Query

[Saeed]

If i have a table with a field say refNo


1001
1002
1003
1001



How woudld be able to get a query telling me the distinct RefNo's with
the number of occurance (duplicates in the table for each RefNo)



Something like

1001 2
1002 1
1003 1

 

[Allen Browne]

Create a query.

Depress the Total button.
Access adds a Total row to the design grid.

Accept Group By under your field.

Drag the field into the grid a 2nd time.
Under this one, choose Count.