Rolling Stockists

**Matt Lunn** · July 25th, 2006, 03:21 PM posted to microsoft.public.access.tablesdbdesign

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** · August 2nd, 2006, 12:38 AM posted to microsoft.public.access.tablesdbdesign

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]

"Matt Lunn" wrote in message
...
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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change column data based on dynamic (rolling) dates?	fergusbell	General Discussion	1	July 25th, 2006 10:29 AM
rolling time period	JJC	Worksheet Functions	4	June 9th, 2005 09:39 PM
Rolling 12 Month Average	J. Johnstone	Running & Setting Up Queries	2	February 17th, 2005 07:05 PM
Z Chart i.e. top rolling annual bottom rolling monthly middle cum.	wat prin	Worksheet Functions	0	January 28th, 2005 03:43 PM
How do I create a rolling average of monthly data in an access.	Albguy	General Discussion	1	November 20th, 2004 03:52 AM