Ms Access Query Run Slow

[BlindPro]

Hello,
I've a query that based on some other queries, when i run, it's slow, and even when i scroll down and right-left a los, is there anyway to make it better?

I attached the file.

 

[mahenkj2]

I do not any reply for your query at the moment but I think you should review the nomenclature of table and field etc. I may also not be using perfect nomenclature but there are certain norms you should use for "naming conventions". I tried this and found helpful when database grows.

In a thread "How to update foreign keys in a table" on page 2, some information on naming convention is available.

best regards.

 

[bob fitz]

BlindPro,

Can you attach a copy of the db in A2003 mdb format.

 

[BlindPro]

Yes, Sure there is the d

 

[BlindPro]

All My problem is Just this, If you know other solution I don't create make-table query