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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount : Att Graham Seach 1
Problem with Cross qry 1
Access Dcount (multiple criteria) 3
query very slow 5
Getting a null value to display zero in count query 1
Eliminating Duplicates via Queries 2
Help with DCOUNT syntax 2
query too slow 1

Back
Top