I noticed a similar thing with this query. I guess complex views suffer the same fate.
Regards
Geoff
>>Thanks Himlar
>>
>>I'm amazed I haven't had this problem before.
>
>I had a case where a query worked for a while - oh, months, perhaps - and then, the selfsame query suddenly started to show this ugly problem.
>
>For reports, I usually use a series of queries one after another, after I figured that this is usually much faster. In one case, a 9-table query took 50 seconds (over a network, and once I had a sufficiently large amount of data); separating it into pieces made it run in 2 seconds.
May all your weeds be wildflowers