Use same date to run two queries

[0REDSOX7]

Hello all,

I need help. i have struggled with this all day and think it is time for help.

I have currently, a form, that when opened, requires users to enter a date range. When they enter this date, it opens up a summary query that will give a summary of total number of records, sum of dollars, average number of days, etc. However, I have a button that this form page that will run ANOTHER query to show the detail, in other words, line by line data. What I do not like is how the user has to enter the date range again.



Is there a way, I can have the date range entered for both queries only one time? this way, when the date range is entered, the user goes tot he summary form query, but can click a button to see the detail lines without having to enter in another date range?

[orange]

You could have a form.


You would ask for a startDate and anEndDate
these would be on text boxes on the form.

Your queries would have the parameters

Select ----- where [Date to Use] Between Forms!Form1.startDate AND
Forms!Form1.Enddate

A long as the form is Open and the dates selected, you can run your queries.

You could also have 2 buttons on the form, such that after entering the start and end dates, you would click a button to run one query and the other button to run the second query.