Crosstab Query that returns Zeros

[Scott]

Is there anyway to have a crosstab query return zeros in
the datasheet when a column heading (set in the query's
property dialog box) doesn't return any data.

 

[John Viescas]

Use an expression in your Value column, something like:

NZ(Sum([AmountSold]), 0)

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411