I have a query that I need to always pull data from the newest past 3 months, so if this query were ran today it would take from months 2,3,4 (Feb, Mar, Apr). Any clue on how to do this?

between dateadd("m",-3,date()) and date()

That didn't work. Does any of that above correspond to a column name?

it should go in the criteria of your date column

Yes, that is exactly where I placed it.

I'm not sure if my question was clear, but the months are in the table so I only want the months 2, 3, 4. (that is how the months are displayed in the table also, just as numbers)

i just created a sample query and put this in and it worked.

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

oh.... i see now
then the way i suggested will not work for u

=( ... do you think it is possible then?

yeah. ull need to search on parsing dates to get the month number then base your query upon that

Then move to this (a variation on Ray's suggestion):

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

sweet that works great, for some reason it pulls data from 2,3,4,5. So I just used 2 and it took 2,3,4. Thanks!~

Sorry but my Manger wants the past 3 months not including the current month.

This Between Format(DateAdd("m",-2,Date()),"m") And Format(Date(),"m") ... works but it takes 3 months plus the current month, any idea on how to skip the current month?

Between Format(DateAdd("m",-2,Date()),"m") And Format(DateAdd("m",-1,Date(),"m")

wow you're amazing... i gave you positive replutation points