J
Jen
I have a crosstab query based off of a table "tblClaims".
TRANSFORM (Nz(Sum(tblClaims.Count),0)) AS [The Value]
SELECT tblClaims.LOC, tblClaims.RvwRsn, Sum(tblClaims.Count) AS Total
FROM tblClaims
GROUP BY tblClaims.LOC, tblClaims.RvwRsn
PIVOT tblClaims.Report In ("C170","RC 85");
My end result should have one row of data for, example:
LOC RvwRsn C170 RC 85
72 BTMJ 25 10
But instead I am getting:
LOC RvwRsn C170 RC 85
72 BTMJ 25 0
72 BTMJ 0 10
Now I have done other more complex crosstab queries where I had the same
problem but resolved it based on how the table was set up. For this
instance, my table "appears" to be set up correctly:
LOC RvwRsn Count Report
Still I cannot get the data how I want it. Any thoughts???
Thanks.
Jen
TRANSFORM (Nz(Sum(tblClaims.Count),0)) AS [The Value]
SELECT tblClaims.LOC, tblClaims.RvwRsn, Sum(tblClaims.Count) AS Total
FROM tblClaims
GROUP BY tblClaims.LOC, tblClaims.RvwRsn
PIVOT tblClaims.Report In ("C170","RC 85");
My end result should have one row of data for, example:
LOC RvwRsn C170 RC 85
72 BTMJ 25 10
But instead I am getting:
LOC RvwRsn C170 RC 85
72 BTMJ 25 0
72 BTMJ 0 10
Now I have done other more complex crosstab queries where I had the same
problem but resolved it based on how the table was set up. For this
instance, my table "appears" to be set up correctly:
LOC RvwRsn Count Report
Still I cannot get the data how I want it. Any thoughts???
Thanks.
Jen