Hello All,
First of all, I'm relatively new to Access, so this may be a simple problem, but I could not find a solution anywhere online.
Basically, I have a Crosstab Query with policy durations (numbers 1-25) on the left as my row headers, and group codes along the top as my column headers. The query I have at the moment successfully produces a sum of the Face amounts for the intersection of each field (i.e. sums all amounts for Group Code = "10NP30" where Duration = 10). Obviously the details of the data is not important, just the concept. Below is a rough idea of what it looks like with made-up data, in case my explaination was a bit vague. I can't seem to get the sample data to be spaced properly in the post, but just imagine row/column headers and a 3X5 dataset.
NP10 NP15 SIWL.....
1 100 250 340
2 30 80 200
3 25 130 150
4 70 90 80
5 80 25 270
... ... ... ...
25 4 7 13
So my next goal is to simply get a cumulative/running total, basically using a "greater than" criteria instead of "equal to" for Duration. For example, I'm looking for the first row to be a sum of all Face amounts for policies in the given Group Code categories for all Durations >= 1, the next row is the sum for all durations >= 2, then Durations >=3, etc., until the 25th row is simply for Duration = 25.
Has anyone encountered this type of problem before/know a way to accomplish this? I wish it was an easy in Access as it would be in Excel! Any help is appreciated, I'm happy to further clarify anything that is still unclear about the problem.
Thanks!!!
-Alex