[AccessD] Syntax question

Andy Lacey andy at minstersystems.co.uk
Fri Jul 2 01:51:26 CDT 2004


Connie
When you are storing the return from the COUNT wrap an NZ(   ,0)  round it.
Can't be more specific as you haven't shown the full code.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----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: 02 July 2004 06:38
> 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/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 




More information about the AccessD mailing list