Speed up Querys

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
Back
Top