Base a secondary query on a date range query and not be prompted

[bethabernathy]

Hi There - Is there a way to base one query on a query with a date range and set it some way so that you aren't prompted twice to enter the date range?

Thanks. Beth

 

[nickjar2]

Hi Beth,

You could always set up a form with 2 fields. In your query you could then have:

between forms!formName!txtBoxName AND forms!formName!txtBoxName2

That way, as long as your form is open, you won't get promted.

Nick