Curent month

[Chimp8471]

I need to run a query, to only include data for the current month, so when we move into the next month, then run the same query it only includes the data for that current month.

Help

Andy

 

[Mile-O]

Criteria (caution: may warble)

Between DateSerial(Year(Date()), Month(Date()), 1) And DateAdd("d",-1,DateSerial(Year(DateAdd("m",1,Date())),Month(DateAdd("m",1,Date())),1))

 

[IgorB]

SELECT * FROM YourTableName
where Month(YourFieldName)=Month(Date()) and
Year(YourFieldName)=Year(Date())

 

[Mile-O]

That too. I just love long crap...