In the following query i would like to add this expression: NewAmt: Iif([invstat] = 1, [InvAmt]*-1, [InvAmt])

can anyone help me out

"SELECT tblDelinAcctListFormData_Temp.Letterhead, tblPDInv_Temp.CustId, tblPDInv_Temp.CustName, tblPDInv_Temp.OnHold, tblPDInv_Temp.Contact, " & _
"tblPDInv_Temp.Coll_Ext, tblPDInv_Temp.DateAcctOnHold, tblPDInv_Temp.Notes, tblPDInv_Temp.LastDateContactedLDC, tblPDInv_Temp.Coll_FollowupDate, tblPDInv_Temp.PaymentMethod, " & _
"tblPDInv_Temp.Phone, tblPDInv_Temp.Fax, tblDelinAcctListFormData_Temp.Region, tblDelinAcctListFormData_Temp.ActStat, " & _
"tblDelinAcctListFormData_Temp.NumPastDue, tblDelinAcctListFormData_Temp.TotDue " & _
"FROM tblPDInv_Temp " & _
"INNER JOIN tblDelinAcctListFormData_Temp " & _
"ON tblPDInv_Temp.CustId = tblDelinAcctListFormData_Temp.CustId " & _
"WHERE (((tblPDInv_Temp.CustId)='" & strCustID & "') AND (([InvAmt]-[AmtPaid])<>0));"

Try

"tblDelinAcctListFormData_Temp.NumPastDue, tblDelinAcctListFormData_Temp.TotDue, Iif([invstat] = 1, [InvAmt]*-1, [InvAmt]) AS NewAmt " & _