do you mean instead of blank you want them to be zero?
in your query you can try either
nz(FieldName,0) and if that doesn't work,
iif(FieldName = null,0,FieldName)
Create a Select query using your crosstab query as the input source. Now use the NZ(FieldName,0) on each of your column values including the total column. This will fill each of your empty spots with a zero. The totals are not rolling up for you because there is a null value as one of the column values for that row.
Post back with more questions.
Bob Scriver Want the best answers? See FAQ181-2886 Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.