Kaup, Chester
Chester_Kaup at kindermorgan.com
Fri Feb 26 08:11:43 CST 2010
I have a query that may or may not return any records. I need to count the number of records returned if there are some or 0 if there are no records. I have tried the following with no success.. RA Inj Count: IIf(IsNull(Count(Nz([PID]))),0,Count(Nz([PID]))) RA Inj Count: Nz(Count(Nz([PID])),0) Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.