Rolling Stockists

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

Guest

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
 
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]
 
Back
Top