how to select current month in a query

D

dlb1228

everytime i open this query i want it to select the current month of a date
field instead of having to put between 1/1/2006 and 1/31/2006 in the
criteria section
 
K

Klatuu

If you are coding it in SQL view
Month(Date()) As CurrMonth

If you are using the query builder. Put this in the Field row where you
want it to show:
CurrMonth: Month(Date())
 
F

fredg

everytime i open this query i want it to select the current month of a date
field instead of having to put between 1/1/2006 and 1/31/2006 in the
criteria section
Click to expand...

The current month "July" is fine, but of what year?

I would suspect you want only the current month AND current year.

Where Format([DateField],"mm/yyyy") = Format(Date(),"mm/yyyy")
 
J

John Spencer

Assumptions:
-- the date field is a datetime field
-- The date field contains only dates without times.

Field: YourDateField
Criteria: Between DateSerial(Year(Date()), Month(Date()),1) and
DateSerial(Year(Date()),Month(Date())+ 1,0)
 
Top