Oh right.

Then why not just do one make table query on the source table where a=b and c=d and e=f etc. Then all results are in one table and subsequent querying of those results should be pretty quick, even if the initial make table query is a little tardy.

Given the conditions on the query of source table (where a=b and c=d and e=f etc.) Can you index any of these a, c or e fields? Might speed things up a little, but knowing access I doubt it'll help much!

Probably missing the point again, but hey, only trying to help!

Cheers