D COUNT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed a qryReconciliation for Accounts,by using the DCount the qry is loading slow I know this is a long shot but can anyone help with any idea
Or has anyone developed an Accounts Package to advise me on my proble
Thank
DD
 
Domain aggregate functions are notoriously slow. You're better to use
Count(), however, I have a feeling you'll probably also need to use a
subquery.

Can you show us the query you have now, and explain what you want it to do?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

DD said:
I have developed a qryReconciliation for Accounts,by using the DCount the
Click to expand...
qry is loading slow I know this is a long shot but can anyone help with any
ideas
 
Back
Top