Using a queries to supply criteria

R

Robert Raley

I am using a queries to supply data to a report. I would like to use the
data from another query to supply the criteria. The primary query has a
field called date id.

The second query looks up the a list of dates by their ids and supplies the
Id number for the most recent date.

How can I use a query in a the criteria grid.

Thanks

Bob
 
V

Van T. Dinh

It sounds like you should be able to use 1 Query (with possibly a SubQuery
inside the Main Query)

Post your Table Structure, the SQL Strings of the 2 Queries with
explanation, some sample data and the result that you want for the Report.
 

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

Changing query criteria to supply a form 3
criteria on form 1
Access Dcount (multiple criteria) 3
Multiple Queries / Same Criteria 3
Date Criteria 4
Using a Form to supply parameters to a query 13
Use In() Expression as Query criteria with guts from Function 1
Process to modify multiple queries simultaneously 3

Top