Stuart McLachlan
stuart at lexacorp.com.pg
Fri Jul 2 01:50:59 CDT 2004
On 2 Jul 2004 at 15:38, connie.kamrowski at agric.nsw.go wrote: > Hi Stuart et al , > > I have come to the conclusion I am getting the type mismatch because the > Count can sometimes be a null value. Is there A way to stop it from > falling over when the count is null? On 2 Jul 2004 > Force it to be an impossible number if it is Null. Try Where WHERE [tblDAuthorityConditionSpecific].[AuthorityID] = " & NZ(RenewID,-1) & "; " -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.