FAQ- Queries

Q/ I have a database that I want to query to pull out records for a financial year running from April to May?

A/ The SQL operator Between can be used to pull out records that fall between two values. An example for a table called tblDates with a column called Mydate is shown below.

SELECT RecordID, Item, MyDate FROM tblDates WHERE Mydate Between #4/1/2009# and #3/31/2010#

The dates are in american format mm/dd/yyyy an annoying consequence of using the hash symbol which dates need to be wrapped in.