Query of a query with a parameter

[RayMilhon]

I have a query that calls another query. The subquery has a date parameter. The calling query also needs to have a date parameter and the value will be the same for both parameters. Is there a way to pass the parameter from one query to the other without having to enter it twice?

[Micron]

AFAIK, only if you use vba. If you know the parameter value, not too hard. If you only know it when the subquery runs, then likely the value has to be found first by using a lookup function - perhaps DLookup. Or you might first retrieve the value from a recordset based on the subquery. In that case, you likely don't run the subquery a second time.

[Welshgasman]

I would set a Tempvar().

[Bulzie]

Is the date on a form? You could just reference that date field in both queries?

[RayMilhon]

Is the date on a form? You could just reference that date field in both queries?

No it is not.

[madpiet]

What if he nests the parameter query inside second query and declares the parameter there?

(Wow, I don't miss this part of Access at all!)

[RayMilhon]

Discovered something I had a typo in the parameter of the 2nd query The parameter in the second query had a space on the end so the names weren't the same which is why it prompted me twice. Once I realized that and matched the parameter name exactly it now prompts me once which is what I wanted in the first place. Thanks for everyone's input.