Select Date Range From Form Pass to Query

[fenhow]

Hello,

Can someone help point me in the right direction?

I am trying to run a query that has a date range selection and returns all data I want within that date range.

I am hoping to create a form that allows me to select a start date and an end date to then pass that information to the query to get my results. I have searched and looked at a lot of calendar controls but none that I have seen give me the select "Range" option;

Here is what it is for;

I have been working on a time and billing database. For every day of the week someone would enter a value say 1 for one day worked along with several other data entries such as expenses etc..

The PK for the database is equal to the payperiod, so for each new payperiod a new record is added with multiple days beneath it and so on.

We require a weekly summary of their time however often the weeks fall between payperiods therfore I need to be able to query all records for that staff member in the database.

Thanks!

Fen How

[fenhow]

Here is a wonderful, very simple solution to my problem. Found it searching the forum.