DATE CRITERIA MAY NOT ALWAYS WORK WITH MS ACCESS QUERY
Learning about ms access query is the means 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 the dividend and avoid silly mistakes, the illogical recordset results, and even errors. One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and its conventions. Take a look at the ms access query below-showing orders before the year 2016 and the intend of the query which suggested a date range from 1st January 2016 to 31st December 2016. The criterion for the above shows >=#01/01/2016 < #31/12/2016# which will not actually return the correct range and instead show what’s known as logical errors (dates outside the range). It’s missing the ‘And’ operator and better still adding the ‘Between’ hand will capture the correct range too. The # (hash