Start and end date

[AuroX7]

How would you make two prompt boxes which ask for the start and end date so you can select all the data between the two dates...

[Start Date?] And [End Date?]

E.g., 01/01/2006 And 07/01/2006
So I can select all the data between that week. I also need to use this for the remaining weeks in January and February. This is really simple...gah. Thanks guys.

 

[Len Boorman]

Put criteria into the query

Between [Please enter Start Date] and [Please enter End Date]

L

 

[AuroX7]

:d

Works a treat. Thank you buddy.

 

[Brianwarnock]

Hi Len

I've always run this type of query from a form as the input is checked for valid dates, is the validity of the dates checked using a parameter query? IE would 31/02/06 be refused? Just curious


Brian

 

[Len Boorman]

Brian

Like you I always run from a form and where possible use cascading combos. Set the second combo to have dates => combo 1 so that the User cannot select an end date that is prior to start date. Then the criteria on the query is still a between.... and but picks up the combo box values selected.

Bit concerned that our original poster amy have found that a bit heavy.

Len

 

[Brianwarnock]

Len

you are right to pitch the answer at the correct level, but sometimes people need a hint of better things, if I wasn't retired I would work out how to use cascading Combos

Brian

 

[Len Boorman]

Brian

Cascading combos, piece of cake, just falls into pieces when you crack it.

I do agree re the hint on better things but was mindful of the number of posts. Okay not an absolute guide but posts and the question together led me along the KISS path.

Retired and still on the Forum every day eh. Its like adrug isn't it

Len

 

[Brianwarnock]

Brian

Retired and still on the Forum every day eh. Its like adrug isn't it

Len

Not everyday and not for long, just to escape the "to do list"

brian

 

[Len Boorman]

That's okay until the lady finds out how to put "to do" on your computer

L