Crosstab query columns not adding correctly

[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

 

[Jen]

Never mind...the RvwRsn field (from 2 different data sources) has extra
spaces from the one source. Used "Trim" and fixed it.