basing one query on th results of another.

[shapman]

hi

I was wondering how you would base one query on the result of another through the same form. I need them to all be under the same command button... i.e. on click run 1st query and then run the second on the results of that query.

How would i go about this, would it have to be a make table query?

Thanks in advance.

Shapman

 

[pbaldy]

A query can reference another query in its FROM clause. You would only have to run the second; the first would be run internally.

 

[ajetrumpet]

Is this question because this was getting to complicated?? =)