Looking for previous month's beginning and ending dates

[Shawn29316]

Hi,
I'm trying to query a table to find records created between the first and last day of the previous month. I'm having no luck with the help feature in Access. Can someone point me in the right direction?

Thanks,

[missinglinq]

First of the previous month

DateSerial(Year(Date), Month(Date) - 1, 1)

Last of the previous month

DateSerial(Year(Date), Month(Date), 0)

You can use these formulas with the Between operator in the criteria field for your date in the underlying query. Using it like this, you need to let Access know that Date is a function, not a field, so you have to add the parentheses after it, like Date(). The criteria would look like this:

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

Linq ;0)>