I want to create a button on a form that will ask me to specifiy a date range
and then apply that date range to two seperate queries and give me both
results.

How do I begin to think about this?
--
Thanks

Start with a form that has two text controls. Use the labels to indicate
which will hold a start date, and which will hold an end date.

Create a query that returns data you want to see. Since you are describing
a "date range", one of the fields of data available must be a date field.
Use parameters in the Selection/criterion "cell" under that date field.
Your parameters will look something like:

Between Forms!YourForm!txtYourStart And Forms!YourForm!txtYourEnd

NOTE -- this approach will only work if the form is open, and the controls
have date values.

One more step -- in design view of the form, add a command button that opens
the query.

When you have this much working, work on the second query using the same
approach. Rather than add a second command button, consider adding the code
that opens the second query to the first command button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"knowshowrosegrows" <(E-Mail Removed)> wrote in
message news:9228C75B-BA6F-4DBF-B1F4-(E-Mail Removed)...
>I want to create a button on a form that will ask me to specifiy a date
>range
> and then apply that date range to two seperate queries and give me both
> results.
>
> How do I begin to think about this?
> --
> Thanks