Simple distinct count Query

  • Thread starter Thread starter Saeed
  • Start date Start date
S

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
 
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.
 
Back
Top