How to put a 0 in a record instead of blank.

  • Thread starter Thread starter ReportTrouble
  • Start date Start date
R

ReportTrouble

I need to put a "0" instead of blank data in record so my expression will work.

I used a iif aplication:
WC: IIf([SumOfWebinar Count]=Null,"[SumOfWebinar Count]","0")

but for some reason the 0 isnt showing up..
please help
 
You can't use the equal sign with Null. Try:

WC: IIf(IsNull([SumOfWebinar Count]),"[SumOfWebinar Count]","0")

BTW, are you sure your original is right? I would think it should be:

WC: IIf(IsNull([SumOfWebinar Count]),0,[SumOfWebinar Count])

which means if it is null, display zero, otherwise display the value.

or use the Nz function

WC: Nz([SumOfWebinar Count],0)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top