Crosstab query constraint of only 1 Value
Posted on 2013-01-07
Hi, I would like to create a crosstab query showing a month-by-month count of claims and also a month-by-month interest value paid on the claims.
Count 20,125 15,892
Value 100,000.00 95,000.00
I haven't successfully thought of a way to overcome the crosstab query's 1 value constraint with a Group by required for at least one Row Heading. If I Group By on the field called claim_no, it will obviously be a very long result set.
Does anyone know if it is possible to do something like this (in multiple steps perhaps)??