Speed up Querys

[Simon]

I have a form that dispalys product inforamtion, i have added a Dlook
up that looks up the Stock level from a Query. This query is very
large as it has, Stock bought, Stock sold, stock damaged, stock
returned ect. I am finding this form a long time to load now becuase
of the large query

Is there a way to speed up a query


Thanks

Simon

 

[John W. Vinson]

I have a form that dispalys product inforamtion, i have added a Dlook
up that looks up the Stock level from a Query. This query is very
large as it has, Stock bought, Stock sold, stock damaged, stock
returned ect. I am finding this form a long time to load now becuase
of the large query

Is there a way to speed up a query


Thanks

Simon

Get rid of as many dlookups as possible, for starters; each one requires that
Access run a separate query of the table! Reduce the number of records that
the query must process to the minimum needed; index any fields used for
searching or sorting; don't retrieve any fields that you don't actually need;
avoid putting any criteria or sorts on calculated fields.

You might want to open the query in SQL view and post it here if you would
like specific suggestions.