Past 3 Months (1 Viewer)

[travismp]

OK here is an easy on for someone. I need to make a query that lists results for the past three months up to present date.

I currently use "Month(Now())" to pull todays date, but what should I add to pull the past three months before todays date up to present date?

Thanks in advance guys and gals.

 

[Sohaila Taravati]

DateAdd("m",-3,Date())

 

[travismp]

Do not understand??

If I do add that no results come up. The field I am pulling from is currently "date" formatted field, and titled 'Date'

You will have to excuse me, I am slow.... thanks for the input thus far, but it is not working for me. Thanks for any more help you can offer.

 

[Sohaila Taravati]

One of the reasons maybe it's that Date is a reserved word in Access and it's not a good idea to use Date for your field. Change the name of your field in your table design and see what happens.

 

[Jon K]

In the query's Design View, enter this criteria in the Date column:

Between DateAdd("m",-3,Date()) And Date()

 

[travismp]

Dude, you are the smartest man alive. It worked great. Thanks for the help. If you guys are ever in Kansas I will be happy to buy you a milkshake....

Thanks again, to both of you for the help.

T.P.