Default Value (0) when Counting in Crosstab Query

  • Thread starter Thread starter BCOLE
  • Start date Start date
B

BCOLE

I have a database connected to an AS400 which is counting
the number of employees in a specific position and
location.

Is there a way to display/enter a zero instead of a blank
space in a counting cross tab query?

Any help/advice would be greatly appreciated!
 
The Nz() function will typically help.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top