"Where" Expression question

[Guest]

I'm building a Macro that opens a report and in the OpenReport I'm trying to
get an expression working in the "Where Condition" field.

The report I'm opening has a subreport in it and each of the two reports has
a date field in it. I want to be able to punch in one date range and have it
apply to both date fields. So, I set up an expression that looked something
like:

([qryOne]![Date] And [qryTwo]![Date]) Between [Beginning Date:] And [Ending
Date:]

Obviously that doesn't work. Any ideas on what the expression should look
like?

 

[Ken Snell [MVP]]

([qryOne]![Date] Between [Beginning Date:] And [Ending
Date:] And [qryTwo]![Date]) Between [Beginning Date:] And [Ending
Date:]

Repeat the criterion for each field.