[AccessD] Syntax question

Andy Lacey andy at minstersystems.co.uk
Fri Jul 2 11:04:51 CDT 2004


Connie
I'm sure someone could help but your actual code would make it easier, like
the lines which use the SQL string in Specific, what you are trying to do
with the result (and how), and what line is failing.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: RE: [AccessD] Syntax question
Date: 02/07/04 14:13

>
> 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
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list