[AccessD] SQL Repost

Martin Reid mwp.reid at qub.ac.uk
Tue Mar 30 11:16:12 CST 2004


All done all working now.

Best

Martin


----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, March 30, 2004 4:49 PM
Subject: Re: [AccessD] SQL Repost


> Hi Martin
>
> Can't you just wrap those expressions in Nz()?
>
> /gustav
>
>
> > Sorry I deleted the origional reply
>
> > Heres the outline
>
> > TM= A+B+C1+ (Higher of D1 or D2)
>
> > TMD= A+B+C1+ (higher of (C1+D1) or C2+D2)
>
> > As before it must be SQL and account for nulls. The IIF works but I am
> > missing something in the syntax re the null values.
>
> > Apologies to gustave as I deleted his email.
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list