Searching for records by a date defined by the user

[andy101]

Hi, I need to build a query where all the records are found between two dates which the user enters, Please Help!

 

[Rich@ITTC]

Hi Andy101

This is a fairly basic area of database design. Have you tried looking in the Help File, in the sample databases provided with Access or in any decent Access Book (Developer's Handbook, Bible, Running Access, etc).

You really need to "get your hands dirty" and have a go! If you find you can't do it, explain what you have tried to date (no pun intended) and what's going wrong. Then I am sure there will be lots of people prepared to offer advice!

Good luck


Rich Gorvin

[This message has been edited by Rich@ITTC (edited 03-23-2001).]

 

[PhilipEwen]

What if the dates entered in the text box don't exist?
i.e. 29th Feb 2001 does not exist.
how do you check to see if the date is valid ?