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