Query using variable (1 Viewer)

I am using a query with a variable which select what records I want to use.

When I use the query from the query above it ask me for the variables again.

I do not want to input the variable again because I have the records I need but must use the 1st query for the secord query to build what I need.

How can I use the first query to build the 2nd query and not have to answer the variable input on the 2nd query? I already have the records needed.

Trust me, I need to build the 2nd query with the 1st query in order to do what I need to do. The first query select the dates I need, then the second query sums only the month and year and not the day of the month. However, I am asked for the dates again. I do not need for the user to put the dates in again. If you know how to do the operation all in one query, that would be great.

Thanks,

Don

If you have the parameters in the first query only, you shouldn't get asked for them again

Col