Use Criteria Count, IF Function, or Other

[andydavidbrown]

I've used the following DCount Function in my primary query which worked, but it is terribly slow and causes Access to not respond.
PXCasework: DCount("[ID]","qry_PXCaseworkAll","[ID] ='" & [ID] & "'")

The results are used to determine if each record in the primary query has any pending casework reflected in the related query qry_PXCaseworkAll. The number of pending casework items is irrelevant to me, I just need to know if there is any pending casework at all.



I know I could use a manual checkbox, but I want the system to automatically flag if the record has pending casework. I've also tried the IF Function without any success. Do you have any suggestions?

[June7]

Is ID a number type field? If so, I am surprised DCount works at all. Do not use apostrophe delimiter for number field parameter.

Build an aggregate GROUP BY query that does the count then join that query to the primary query.

[andydavidbrown]

Thanks June7, that worked very well. ID is a text type field with alphanumeric account numbers.