how do I query for date values?

A

andrea5977

I have my date values set up as 00/00/0000. Is it possible for me to query
for all entries in a specific month (i.e. all June birthdays)?
 
K

KARL DEWEY

Assuming that your field is a DateTime field and not a Text field then use
this as an output field in the query design view grid --
Month([YourDateTimeField])

Use this as criteria in the query design view grid --
[Enter the month ( 4 or 11 )]
 
Top