Unanswered: Help with on syntax for simple subtraction in query
I need to subtract one field from another in a query. I have
in the 'field' line of my query, but if the AmountPaid field is empty, then the AmountOutstanding field also remains blank. I want the AmountOustanding field to be the same as InvoiceAmount, except if a payment has been made (AmountPaid), when [AmountPaid] should be subtracted.
I'm sure this is an easy answer for somebody. Many thanks.