Date query

[Skirrow]

Can anyone help with this...?

I have 3 queries all of which filter the results by date. I do this by setting the date field to WHERE and entering >[StartDate] AND <=[EndDate] as criteria

StartDate and EndDate don't exist so when I run the query it pops up a box and which asks me for the startdate and another for the enddate.

That's all well and good until I then make another query which pulls data from the 3 first queries. Now of course it asks for the start and end date 3 times. It works but can anyone suggest a better way of doing this so I only have to enter the dates once?

Cheers!

 

[Brianwarnock]

Pick the start and end dates from a form, call it frmDates, then your criteria will be > Forms!frmDates!Startdate etc

Brian

 

[Skirrow]

Ahh, I see, brilliant. I think you have just opened up a whole new world to me.... Cheers!

 

[Brianwarnock]

HTH, I also put command buttons on the form to drive the queries/reports.

Brian

 

[Skirrow]

It does indeed.. cheers again, just working on a pop up calender and a button to open the query. Never used forms for much more than a nicer way of displaying table data, I know see their true power...