I have these records:
 Name Code
 Jane 309.5
 Sam 411.2
 Jay 201
 Sunny 522.3
 Claire 411.2
 June 201
 Max 201
 Sue 309.5
 Sue 411.2
 Jay 522.3
 Kay 201
 John 201

I want a summary of those records in the following manner:
 Code Count
 309.5 2
 411.2 3
 201 5
 522.3 2

Can someone please show me how to query this in Access to get the result that I wanted. Your help is greatly appreciated. Thanks a million.

Create a new query in SQL View and paste this in the window:

SELECT tblGroup.Code, Count(tblGroup.Code) AS CountOfCode
FROM tblGroup
GROUP BY tblGroup.Code
WITH OWNERACCESS OPTION;

Change tblGroup (everywhere it appears) to your table name.

Regards,

Beth M