[AccessD] Syntax question

In this case use count(*) instead of specify field name.

andrew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
connie.kamrowski at agric.nsw.gov.au
Sent: Friday, 2 July 2004 1:38 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Syntax question

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 

at 15:11, connie.kamrowski at agric.nsw.go wrote:

> 
> Hi guys,
> 
> Am trying to code an SQL statement behind a form as follows
> 
> RenewID = Me.AuthorityRenewalID.Value
> Specific = "COUNT([SpecificCondition])FROM 
[tblDAuthorityConditionSpecific]
> WHERE [tblDAuthorityConditionSpecific].[AuthorityID] = " & RenewID &
"; "
> 
> The variables have been declared as integers but I am getting a type
> mismatch error on the second sentence, The value for RenewID is
working 
but
> it won't let me past this
> 
The only thing I can spot is a missing space before "FROM"

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.





This message is intended for the addressee named and may contain 
confidential information. If you are not the intended recipient or 
received it in error, please delete the message and notify sender. Views

expressed are those of the individual sender and are not necessarily the

views of their organisation.
-- 
_______________________________________________
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.