Zero value in query

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

From my table with only checkboxes I created a query and crosstab query. Now
I want to see also the 0 values Is this posisble? Now the fields are blank

Herman
 
The values are blank because there are no matching records at the particular
row/column heading combination. You can generate a zero by using the NZ
function. For example, if you're summing a column called Quantity, you can
change the Field to this expression:

Qty: NZ([Quantity, 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)
 
Back
Top