Martin Reid
mwp.reid at qub.ac.uk
Tue Mar 30 09:21:17 CST 2004
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.