Between and DateAdd Problem

[JJ]

Hello, I've designed a database and I need help creating a query for it. In
the database, there are dates in the future when contracts expire. I need to
be able to create a query that allows me to pull the records that are either
30,60, 90, or 120 days away. For example, I want to be able to see the
records that are 0-30 days away, 31-60 days, 61-90, and 91-120. Is this
possible? Thanks

 

[Klatuu]

A bit more info would be useful.
Is this for a report or a form, or what?
Do you want to return one recorset with just a specific date range, or do
you want to return something that shows which data range the record is in?
From where are you running the query?
What version of Access?

 

[Ron2006]

The other question is "Away from what?"

 

[Klatuu]

Good observation.
I, without thinking too deeply, assumed Date()
But then I am sure you know about Assume <g>

 

[JJ]

Thanks for all the suggestions but I got it working. I just used this formula
and changed the days as I needed

Between DateAdd("d",+31,Date()) And DateAdd("d",+60,Date())

That would give me dates from 31-60. And I just worked around this. Thanks.