Hi Chris

I have done a lot of testing on this, and I think I nailed it.

When I pick a customer range BREE40 to BREE40, item range DABAR4620 to DABAR4620, for YTD, it takes about 1 minute to search and finds three matches, which is correct. It's the same no matter whether I make the item number or the customer first.

When I do nothing else but change the ending item number to DABAR4621 (there is no such number), it takes 5 seconds. Still finds the same three matches.

When I do nothing else but change the ending customer to BREE41 (there is no such customer), it still takes about 1 minute. Still finds the same three matches.

So there's something about picking a single item that slows the system down tremendously.

This is on my standalone Win7 PC.

If you would like the data (it's large), I'll upload it to you, let me know.

Steve