how do I query for date values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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 )]
 
Back
Top