Selecting in between dates

me · Nov 19, 2004

How do you do selection in between dates in a query? For example,
qryBetweenDates would be from Mar 20, 2004 thru Mar 27, 2004. This comes
from a table of Events where the dates are located at and Individuals where
the People names are.

TIA

Roger Carlson · Nov 19, 2004

In the criteria for the date field, have something like this:

BETWEEN #3/20/2004# AND #3/27/2004#

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

me · Nov 20, 2004

Peter,

Thanks for that extra information on data input validation.

Aaron