Mr. Southern
Registered User.
- Local time
- Today, 00:09
- Joined
- Aug 29, 2019
- Messages
- 90
you would need to test it
you've done 1
try 100, then 1000
But check indexing, I keep saying it, you keep ignoring itthat will make the biggest difference regardless of the number
I got very busy the past few days and I can now finally look at this again.
I made my original qry_DPStop into an append query which updates a table. In the table the AccountNumber is indexed. From that table, I then use the subqry_DPStop to get the Top 5. It appears to be functioning but it does take approx 5 min to load.