[AccessD] Syntax question

connie.kamrowski at agric.nsw.gov.au connie.kamrowski at agric.nsw.gov.au
Fri Jul 2 00:38:12 CDT 2004


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.


More information about the AccessD mailing list