Rolling Stockists

[Matt Lunn]

Hello all,

I've got a table which shows Account, WeekEndDate and Volume and it shows
data from the last 52 weeks. What I'd like to be able to do is create a table
that, for every week, shows which accounts have sum of volume greater than 0
from the previous 8 weeks. Is this possible?

Thanks,
Matt

 

[David F. Cox]

Sounds like you need a make table grouped query. Group by Account, Sum
volume with criteria >0, and Where weekend date is not shown and is > [from
date]