Filtering filtered information with a macro

[Crystal McKee]

How do I get a macro to filter a macro and then run another query on the results from the first? Please help!!!

 

[Crystal McKee]

That should have said:
How do I get a macro to filter a set of records and then run another filter on the results of the first? Thanks!

 

[dandgard]

This really doesn't sound like a macro problem. From your descriptio
you might think about running a query based upon a query.

if your first query runs with the first set of criteria then you creat
another query that is based on the first query where you can insert th
next set of criteria.

so from the macro you just want to make sure that the criteria are se
for both queries and run the second query.

The problem is once you run a query in a macro, how do you save th
recordset to use for the next set of criteria.

You could do this if the first query was a make table or append quer
and the second query was based upon the info in the table affected b
the first query

 

[dandgard]

This really doesn't sound like a macro problem. From your descriptio
you might think about running a query based upon a query.

if your first query runs with the first set of criteria then you creat
another query that is based on the first query where you can insert th
next set of criteria.

so from the macro you just want to make sure that the criteria are se
for both queries and run the second query.

The problem is once you run a query in a macro, how do you save th
recordset to use for the next set of criteria.

You could do this if the first query was a make table or append quer
and the second query was based upon the info in the table affected b
the first query

 

[dandgard]

This really doesn't sound like a macro problem. From your descriptio
you might think about running a query based upon a query.

if your first query runs with the first set of criteria then you creat
another query that is based on the first query where you can insert th
next set of criteria.

so from the macro you just want to make sure that the criteria are se
for both queries and run the second query.

The problem is once you run a query in a macro, how do you save th
recordset to use for the next set of criteria.

You could do this if the first query was a make table or append quer
and the second query was based upon the info in the table affected b
the first query