Using a queries to supply criteria

  • Thread starter Thread starter Robert Raley
  • Start date Start date
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
 
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.
 
Back
Top