Creating a query from another query with parameters

G

Guest

I created query1 which uses parameters entered from a separate form. I then
created another query called Query2 that pulls in some of the fields from
Query1.

the problem is when I run Query2, I get no response due to the fact that the
criteria fields in Query1 are not static. i thought maybe to have Query1
open and populated would offer the data to Query2, but no go.

How can I open Query2 with the data from Query1 (Form to Query1 to Query2)?

Thanks,
Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
how to pass a parameter to a query base of a query that is the base of a report 0
JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15
Variables in Query 1
MS-Access sum problem in query 2
Crosstab query totals 3
Query based on a query 3
One Report based in two distinct queries (?) 2

Top