Quick Return Query

[worldwidewall]

Hi

I have a query that runs just fine and takes about 1 minute to run on average. I have vba code that uses Dlookup to determine if the query returns any records. The problem is that each time it runs it has to crunch all the data, all I care about is if there is any result at all. Is there a way to get the query to stop after it finds one record to speed things up greatly?

Thanks

Dave

[June7]

No. Queries run until they are done. This is why calling VBA functions from query has risks. If the code is flawed and has infinite loop, a query would never finish.

There might be alternatives you could employ in VBA code using recordsets and looping structures.

[worldwidewall]

That's what I was afraid of, thanks.