Am trying to build an accounts receivable aging program. To put the
amounts in the correct columns I am using the following formulas -
For the 1st column:
Col_1: IIf([Due]>[Aging Date]-30,[BalanceDue],0)
For the 2nd column:
Column_2: IIf([Due]>[Aging Date]-60,IIf([Due]<[Aging
Date]-30,[BalanceDue],0))

And so on . . . The names in the brackets are other column headings in
the same query. [Due] is a date field; [Aging Date] is a date field
that is input by the "operator" upon query execution; [BalanceDue] is
a currency amount that is calculated from other amounts in the same
query.

When executing the query I get the "#Error" message displayed in the
output.

Please help!

Thanks

Ralph