Martin Reid
mwp.reid at qub.ac.uk
Tue Mar 30 02:00:09 CST 2004
Stuck on this Has to be done in SQL if possible as they want to use it as the criteria in a query Need to work out the following using SQL If D1 > D2 or D1 = D2 Then TM= A+B+C1+D1 Else TM= A+B+C1+D2 Next One is A+B+ Higher of (C1+D1) OR (C2+D2) Martin