Query Question

[MaxEd]

How do I speed up my queries? On my query it returns almost 4000 records before the main form loads up. It is kind of slow, is there anyway to speed it up?

 

[AWithers]

Have you looked at the indexes on the underlying tables?

otherwise you might want to try and write the same query in a different way e.g. using joins rather than sub queries or vice versa

Andy