Hello,

I am creating a new form which is no problem but I would like to create a search page that will allow me to search the date a record was added to the database. I plan on using a Date format when creating the database table but if the format is say YYYY/MM/DD how would I code to display the records from one day to the next.

For example: from March 20, 2005 to March 25, 2005

I will be using the following format,

Database name: WOR
Table name: accounts
Date Field Name: General_Date

I hope I have provided enough information if not let me know. I need help getting started with this query so if you could show as much information as possible that would be great.

Thanks in advance.....

Did this not end up working out for you?

Not exactly no, I want the user to enter the date ranges to search for. For example the form would have 2 text fields that the user could enter the starting date and the ending date.

The database doesn't care where the query comes from, user or not... You can use that query with the user-supplied values.