[AccessD] IIf

Bridget Doran bridgetd at biostat.umn.edu
Thu Feb 26 09:16:06 CST 2004


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




More information about the AccessD mailing list