Can't get my query to return the number zero

[chubby]

I have a query which counts the number of females assigned to the Engineering Department. The problem is sometimes there are no females in Engineering, I need my query to return a zero not Null.

I tried the IIF(IsNull([field1],0,)

Someone said use =NZ but how???

 

[tlbroadbent]

How are you querying the table? The following query and function should return 0 rather than NULL if no records are found.

Select count(col1) From tableA Where gender='F'

=DCount("[col1]","tableA,"[gender]='F'&quot Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[chubby]

Thanks