Query1 -> Query2 -> Query3-> Report

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
 
S

Steve in MN

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?
 

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
Query keeps looking for Query1 field 3
Crosstab query totals 3
Query changes on its own 2
loop though records in a query? 5
SubQueries in Column 1
Check boxes in forms to call a query 8
how to pass a parameter to a query base of a query that is the base of a report 0

Top