Between and DateAdd Problem

J

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
 
K

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?
 
K

Klatuu

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top