Windows XP 
Access 2003
For the life of me I can't figure out how to do this, so hopefully someone can help me. Let's say I have a table which looks like this:
The first column is name, 2nd is year, 3rd is quantity. Very simple spreadsheet.Code:Bill 1990 72 Bill 1991 73 Bill 1992 71 Bill 1993 55 Bill 1994 78 Bill 1995 73 Stan 1990 130 Stan 1991 122 Stan 1992 100 Stan 1993 115 Stan 1994 101 Stan 1995 112
What I need to do is have the program spit out a spreadsheet which then shows me the total quantity for each person over every 3-year span. So I would want the resulting graph to look like this:
What this would be is the first column is again the name, the 2nd column is the first year of my 3 year span, and the 3rd column is the sum. So just taking the first row, that would be telling me that for the 3 year period going from 1990-1992, Bill's total quantity is 216. And the next row is Bill quantity for the three year span of 1991-1993. And so on.Code:Bill 1990 216 Bill 1991 199 Bill 1992 204 Bill 1993 206 Stan 1990 352 Stan 1991 337 Stan 1992 316 Stan 1993 328
I've tried everything I can think of in the design view format in queries to make this work, but I can't do it. Any ideas?
Reply With Quote
