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:
Code:
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?