Searches by Date Range

[RichK]

I have made a database that seems to be working well . I just need to be
able to search by date ranges. How would I go about doing this? As much
detail as possible as I am an advanced newbie

TIA !


Have a great day to all!

Rich K

 

[Rick]

Search?

Are you wanting to run a query that will pull records between a certain date
range?

If so, build the query. Pull your date field to the bottom half of your
window of the query builder. In the 'criteria' under the date field enter
something like...

between [StartDate] and [EndDate]

Pull any other fields you wish to see in your results.

When you run the query (click on the red exclamation sign) it will ask you
to enter a date range.

Hope that is what you need.

Rick

 

[MikeM]

First thing's first. Make sure the data type for your date
field is of type date/time.

To search for a date range, you could create a query.
Include all necessary fields that you want to display, and
underneath the date field type the following into criteria:

Between 2/2/2000 and 2/2/2001

the query will return all records that are dated between
February 2, 2000 and February 2, 2001.