Query too slow

[abhi.karnawat]

the following query is based on 2 other queries.
i have a table stock and stockJ, from theses tables i query 2 queries of stock that is unsold, after that i have query the comes from both these queries where there are 2 fields linked namely Stock location and Jewl No

whenever i want to retrieve data it takes about a minute before data is displayed.. in both tables there are about 5000 records total..

how can i speed this up?

regards,
abhi

 

[llkhoutx]

Try breaking you query into 2 queries, with 1 join each.

Is either table a non-Access table?