Query rolling dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I don't know if I'm drawing a blank and missing something easy and obvious,
but what I'd like to to is take my table that has 2 date columns and build a
query that rolls through the dates, seaching for any 7 day block that meets a
certain condition. I just can't figure out how to do it. I could probably
export the data to an Excel sheet and play with VBA to do that, but I'm
thinking there has to be a way I could do it through a query.

Thanks in advance,
Paul
 
Hi all,

I don't know if I'm drawing a blank and missing something easy and obvious,
but what I'd like to to is take my table that has 2 date columns and build a
query that rolls through the dates, seaching for any 7 day block that meets a
certain condition. I just can't figure out how to do it. I could probably
export the data to an Excel sheet and play with VBA to do that, but I'm
thinking there has to be a way I could do it through a query.

Thanks in advance,
Paul
Click to expand...

I'm sure there is, but I don't understand the question!

You have two date fields. Which field are you searching? What
constitutes a "block"?


John W. Vinson[MVP]
 
Back
Top