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 >