I cant group by count a query with a OR criteria

[Fahad313]

can somebody help me with this problem:
I created a query from a query and a table. it has many criteria using the OR criteria. i grouped the Primary key by a Count total. when i run the query, it gives me the total of each record. i want it to show me the count of all the records.

[ItsMe]

As you have discovered, using "Count" in a query counts unique data. Each record's PK is going to be unique and its count will always be 1.

I would use VBA behind a form to get a count of records within a recordset.

[Fahad313]

thanks
but i am not expert to use vba

[ItsMe]

You could try adding an alias to your Totals Query. Include the DCount function within your alias. This may cause a noticeable performance hit.

MyCount: DCount("Patient ID","Included Patients Query","Patient ID >0")