Query rolling dates?

[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

 

[John Vinson]

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

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]