If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rolling Stockists
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 |
#2
|
|||
|
|||
Rolling Stockists
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 | |
Display Modes | |
|
|
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 |