>Thanx George, but I tried that and I'm still getting the same message. Is SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) amount a vailid column refrence?
Bill,
You're missing the AS clause
SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) AS amount
in several places it looks like as well.
George
Ubi caritas et amor, deus ibi est