Microsoft Access Question

Re: Microsoft Access Question

if you'd like to find all records within Jan, for example, then your criteria would like something like this:

between #01/01/01# and #31/01/01#

And btw; when ever you are playing with the date you have to use the hash with it, cause that's how Access identifies the date.

:biggthumb