Query1 -> Query2 -> Query3-> Report

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi Guys,

I have a query that is generated from other query and this other query is
generate from another query, I use final query in a report and is very
aggregate compared to the first query, the thing is that now I want to filter
the report by the date field, but the problem is that I don’t have the date
field in the query I am using in the report because is aggregated data, the
date field is in the first query the one that originated the other 2 queries,
I can’t type any conditions in the main query because this query generate
other queries. Any idea of how to deal with this situation will be
appreciated.

Thanks
 
Cant you simply create another query at the beginning of the process to
filter the date range and then have your query 1 look at this filtered query?
 
Back
Top