Date Range for Reports

I have a button on a form that opens 3 reports. Each report needs to be
filtered by different date ranges. I can set up each one with a query
criteria of [Enter End Date] and [Enter start date], but this would have the
user putting in 6 dates...I'd prefer to have the report filter automatically.


For example, report only if a Test Date was within 60 days of today, a
Medication was within 120 days of today, etc...

Any thoughts?

Then just change the criteria in your query.

For "within 60 days of today" use Date()-60

For within 120, use Date()-120

etc.



--
Rick B



"5843" wrote in message
...
I have a button on a form that opens 3 reports. Each report needs to be
filtered by different date ranges. I can set up each one with a query
criteria of [Enter End Date] and [Enter start date], but this would have
the
user putting in 6 dates...I'd prefer to have the report filter
automatically.


For example, report only if a Test Date was within 60 days of today, a
Medication was within 120 days of today, etc...

Any thoughts?

I'm not sure if that what you are looking for, but try this

Select * From TableName Where [Test Date] Between DateAdd("d",-60,Date())
and Date()

Select * From TableName Where [Medication] Between DateAdd("d",-120,Date())
and Date()

--
I hope that helped
Good luck


"5843" wrote:

I have a button on a form that opens 3 reports. Each report needs to be
filtered by different date ranges. I can set up each one with a query
criteria of [Enter End Date] and [Enter start date], but this would have the
user putting in 6 dates...I'd prefer to have the report filter automatically.


For example, report only if a Test Date was within 60 days of today, a
Medication was within 120 days of today, etc...

Any thoughts?

To correct myself

Select * From TableName Where [Test Date] Between Date() And
DateAdd("d",60,Date())


Select * From TableName Where [Medication] Between Date() And
DateAdd("d",120,Date())


--
I hope that helped
Good luck


"Ofer" wrote:

I'm not sure if that what you are looking for, but try this

Select * From TableName Where [Test Date] Between DateAdd("d",-60,Date())
and Date()

Select * From TableName Where [Medication] Between DateAdd("d",-120,Date())
and Date()

--
I hope that helped
Good luck


"5843" wrote:

I have a button on a form that opens 3 reports. Each report needs to be
filtered by different date ranges. I can set up each one with a query
criteria of [Enter End Date] and [Enter start date], but this would have the
user putting in 6 dates...I'd prefer to have the report filter automatically.


For example, report only if a Test Date was within 60 days of today, a
Medication was within 120 days of today, etc...

Any thoughts?