[AccessD] Re: Quick Syntax question

At least you have the solution now! :)


Andrew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Monday, 5 July 2004 10:00 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Re: Quick Syntax question

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.



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



CONFIDENTIAL COMMUNICATION
If you receive this confidential communication by mistake, please contact the sender immediately by return electronic mail.
Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of
the Worsley Joint Venture - Bauxite/Alumina Operation. Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests: Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, Japan Alumina Associates (Australia) Pty Ltd 10 percent, Sojitz Alumina Pty Ltd 4 percent.