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

 

[Jeff Boyce]

Matt

I don't believe you need to create a new table to do this (that's how you'd
approach it in Excel, but Access is a relational database).

Have you looked into using queries to calculate (and display) what you're
looking for?

Regards

Jeff Boyce
Microsoft Office/Access MVP