Introduction
Access Queries: Date Criteria May Not Always Work with MS Access Query
Learning about ms access query is the key to a good database management system as it is the heart of any database application.
There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors.
One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it’s conventions.
Take a look at the ms access query below showing orders before the year 2016 and the design of the
query which suggested a date range from 1st January 2016 to 31st December 2016.
It’s missing the ‘And’ operator and better still adding the ‘Between’ operator will capture the correct range too. The # (hash sign) is the correct convention and good check to ensure it’s the right data type too (date/time in this case).
Ben Beitler
https://www.accessdatabasetutorial.com/
ben@accessdatabasetutorial.com
United Kingdom
London
Learning about ms access query is the key to a good database management system as it is the heart of any database application.
There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors.
One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it’s conventions.
Take a look at the ms access query below showing orders before the year 2016 and the design of the
query which suggested a date range from 1st January 2016 to 31st December 2016.
It’s missing the ‘And’ operator and better still adding the ‘Between’ operator will capture the correct range too. The # (hash sign) is the correct convention and good check to ensure it’s the right data type too (date/time in this case).
Ben Beitler
https://www.accessdatabasetutorial.com/
ben@accessdatabasetutorial.com
United Kingdom
London
Contact Info
Address:
Devonshire Square, London, United Kingdom
Devon
England
United States
Devon
England
United States
Tel:
Website:
https://www.accessdatabasetutorial.com/
Hours of operation
| From | To | From | To | From | To | ||
|---|---|---|---|---|---|---|---|
| Monday | Open | ||||||
| Tuesday | Open | ||||||
| Wednesday | Open | ||||||
| Thursday | Open | ||||||
| Friday | Open | ||||||
| Saturday | Open | ||||||
| Sunday | Open | ||||||
