Creating a Date Range Form

[daniejm]

Hi all,

I'm a novice to Access. Any help is appreciated.



I've got a database now with 40,000 entries in it. I want to sort them by an expiration date, which is a column called "xdate." I've formatted the xdate column to modify how the date appears. The format is m/dd, because these entries are not "year specific."

For ease of use, I'd like to create a form that runs a Query to display a certain range of dates that I have entered. For example:

START DATE: 1/1
END DATE: 1/31

Would display all records matching between (and including) these dates.

Here's what I have... I have the form setup to run the query ("DateRangeQuery"). My query Criteria is this:

Between [Forms]![DateRange]![txtStartDate] And [Forms]![DateRange]![txtEndDate]

Unfortunately, this is not filtering my values. Running the query still gives me all 40k of my records, so it's not filtering whatsoever.

What am I doing wrong?

[daniejm]

Well, figured it out. Had to format my Query Criteria a little differently to reflect the date format. Ended up looking like this:

Between Format([forms]![DateRange]![txtStartDate],"m/dd") And Format([forms]![DateRange]![txtEndDate],"m/dd")