S Scorpion Registered User. Local time Today, 16:15 Joined Jun 15, 2000 Messages 35 Feb 23, 2001 #1 In a report, how do I tell Access to place a zero in a field if the field is blank.
D dlgates Registered User. Local time Today, 16:15 Joined Feb 21, 2001 Messages 12 Feb 23, 2001 #2 =iif(isnull([fieldname]),0,[fieldname])
W Webmaster@worksnotfun.com Registered User. Local time Today, 16:15 Joined Jan 28, 2002 Messages 15 Mar 25, 2002 #3 I tried this, on a report that is not running off a query, and I still get 1.
H Happy YN Registered User. Local time Today, 16:15 Joined Jan 27, 2002 Messages 425 Mar 26, 2002 #4 look up nz fuction
S SiE Registered User. Local time Today, 16:15 Joined Mar 1, 2002 Messages 25 Mar 26, 2002 #5 in the format for the cell on the report enter :- 0.00;;;0 the first option is the format of the field displaying. The end option is what appears if the field is null in this case 0. It could be 0.00% or even a string like N/A. hope this helps
in the format for the cell on the report enter :- 0.00;;;0 the first option is the format of the field displaying. The end option is what appears if the field is null in this case 0. It could be 0.00% or even a string like N/A. hope this helps
