Simple distinct count Query

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top