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

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
 
R

Roger Carlson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Function 2
Nz or Iif 8
Printing Blank instead of Zero or 0 2
return a "0" instead of a blank field 2
Counting in Query 3
Count <>0 not working 3
Blank or Null in a Cross Tab Query in Access 2003 2
Access count a field in access report 2

Top