Slow performance => Seect Query

Hello Salima,


Thank you for your question regarding Access query.

There are many options available to optimize slow queries, the idea of a form will not necessarily solve this, most optimisation will require good knowledge of SQL. However, you could try only including data columns that are essential, and also try running the Optimizer in Access. From the Database tools ribbon in 2007, under the section called Analyze, select the Analyze Performance option.
From the dialog box, select queries, and tick the queries to check. Access will make suggestions on how to optimize for best performance.
This may help in speeding up the query.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer