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
|
|||
|
|||
Cumulative totals
Hi everyone, I would like to create cumulative totals per month to create a
chart. I have got this far: SELECT Data.Region, Data.[Month Year], Count(Data.[Month Year]) AS [CountOfMonth Year] FROM Data GROUP BY Data.Region, Data.[Month Year] HAVING (((Data.Region)="Leicester" Or (Data.Region)="Nottingham" Or (Data. Region)="Northampton" Or (Data.Region)="Kettering" Or (Data.Region)="Derby") AND ((Data.[Month Year]) Is Not Null)); ...but I really have no idea about how to add the values together for both Leciester and Nottingham on a monthly basis...as the query needs to produce both the individual region values and the combined values but they are separated by region. Any ideas would be gratefully appreciated Sam -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|