troubleshooting Question

Crosstab query constraint of only 1 Value

Avatar of IEHP1
IEHP1Flag for United States of America asked on
Microsoft Access
47 Comments1 Solution469 ViewsLast Modified:
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.


                              2012-01        2012-02
            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)??
Join our community to see this answer!
Unlock 1 Answer and 47 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 47 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros