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:
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
The first column is name, 2nd is year, 3rd is quantity. Very simple spreadsheet.
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:
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
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.
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?