Count Unique Records

[kramerica]

My Query in Access 97 is designed to count records. If I change the query parameter to "Unique" = Yes I get the same results in the query. If I remove the count field it returns the correct number of records, yet when I add the count field it gives the total number of records in the table?! I am open to any solution. I am using the code to generate charts and graphs, the counting of unique records is just an interim step an I was using a query to do it.. Is there a way to do this with VB Code?

 

[Maquis]

Set up a group by query to return the unique records then in VB you can use a DCount() function on that query to capture the # of records. Maq
<insert witty signature here>