Stuart McLachlan
stuart at lexacorp.com.pg
Sun Jul 4 21:00:15 CDT 2004
On 5 Jul 2004 at 10:51, connie.kamrowski at agric.nsw.go wrote:
>
> Specific = "COUNT([SpecificCondition]) FROM
> [tblDAuthorityConditionSpecific] WHERE
> [tblDAuthorityConditionSpecific].[AuthorityID] = " & RenewID & " ;"
>
You can do this with a simple DCOUNT:
Specific = DCOUNT("SpecificCondition",tblDAuthorityConditionSpecific","AuthorityID = " & RenewID)
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.