[AccessD] Syntax question

I don't think Count can return as Null (because a zero count is zero).
However, just out of curiousity, is that the EXACT SQL you are using?  If
so, you need a space before FROM, and I would recommend using
Count([SpecificCondition]) As CountOfSpecificCondition, thought I don't
think that is absolutely necessary.

Drew

-----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, July 02, 2004 12:38 AM
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