Filtering a query based on results of another query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I would like to filter a query based on the results of another query. The
results of the first query may have more than one record.

Thanks
 
Dear Karen:

Two (out of many) ways of doing this come to mind, depending on more
specifically what you want to do.

If the subsidiary query shows which rows you want to display, using it as a
subquery of an IN() clause would be useful.

In other cases, an JOIN of the two would be useful.

To be of more help, considerable detail may be necessary.

Tom Ellison
 

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

Query using multiple values from one text box 7
Query Filters 1
Delete Query: Could not delete from specified tables 0
Multiple Parameter Crosstab query filter by form 1
Query from Multiple Checkboxes 1
Access Determine what query to run based on a checkbox 0
Filtering with Query 1
Display query results only if field is not null 3

Back
Top