[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.