[AccessD] IIf

Bridget,
 
Try one of the two possibilities below:
 
=iif(Isnull([4]),0,[4])
 
or
 
=iif([4]=””,0,[4])
 
Paul






Message date : Feb 26 2004, 03:19 PM
>From : "Bridget Doran" 
To : accessd at databaseadvisors.com
Copy to : 
Subject : [AccessD] IIf
Does anyone know if the Immediate If can be used with crosstab data? I'm
trying to report with this data and I've tried this: =IIf([4]=Null,0,[4])
on the report as well as in the query and I don't get any errors but I
also don't get what I want which is a zero in the case of no data.

Thanks - I'm using Access2K

-- Bridget Doran

Bridget Doran
Biostatistics Consulting Lab
University of Minnesota
A444 Mayo Building
612.626.7009
bridgetd at biostat.umn.edu

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime