I have created a report based on a query and I need help with pulling a report based on a date range. I used the "Type beginning date and ending date" in the field of the query but this was not liked by the users.

So I have tried to create a date rage selector form and use my calendar to select the date range but I can not get it to pull the dates selected.

Any ideas?

you are using a form to select the dates correct?

are you using

between [forms]![frmname].[startdate] AND [forms]![frmname].[enddate]

I have attached my DB so you can see what I'm trying to do and not very successful at it either.

Jkitle I saw your database and to tried to figure what you wanted.I used the Product Date because you dint specify which date to use.
also I added a Calender I had downloaded by Lebans which to say the least is DABOMB so try and see what I have done. You can copy the modules to your Dbase but dont change anything except the Utility one . Look at the code behind the Test form .Also your Inventory Table was Empty so I could not use it,so when you open the report you will see a few parameters just say ok to all and the report will open . Any problems just ask
NB if you want another date just use the criteria as in the Products date and delete the one I have used

coyote,

I really appreciate your help. The calendar option is great!