Count unique values

  • Thread starter Thread starter john
  • Start date Start date
J

john

My Access-97 table looks like this:
Field 1
A
A
B
C
C
C
I'd like to make a query which gives me a new table with all unique values
of Field 1 and a count of the number of times they appear in the field
throughout the table. So the answer should look like this:
A 2
B 1
C 3
I'm relatively new at Access and have not been able yet to come up with a
solution via Help.
Can someone help me? Thanks,
john
 
1. Create a query into this table.

2. Depress the Totals icon on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Drag Field1 into the grid.
Accept Group By in the total row.

4. Drag Field1 into the grid again.
Choose Count in the total row under this second instance.
 
Splendid, works like a charme!
Thanks,
john

Allen Browne said:
1. Create a query into this table.

2. Depress the Totals icon on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Drag Field1 into the grid.
Accept Group By in the total row.

4. Drag Field1 into the grid again.
Choose Count in the total row under this second instance.
Click to expand...
 
Back
Top