Hi all,
Happy New Year!!!!!!!
I have a query that popultes a form... OK
It has the tbl fields on it, and some calculated fields.
I am trying to use an IIf statement in one field of my query to either let me put value in or automatic insert value in if is not null....
Not real sure how to word that....
Field in table/query OpenBalance, standard currency field
Calculated Field in Query DueAmount, Field is DueAmount: [TotalPay]-[PaidAmount] This only gets value when loan fields are entered. Otherwise, null
I have tried tons of things and cannot seem to make it work at all.
So, If the calculated field is null, then I want to be able to fill in the OpenBalance value manually, if its not null, then I want the value of the calculated field inserted into OpenBalance field.
Obviously this does not work at all, just gives a parameter box.... but was the last thing i tried.
If(IsNull([DueAmount]),[OpenBalance],[DueAmount])
Is there a way to put an expresion in the OpenBalance field criteria that will allow me to enter the OpenBalance amount if the DueAmount isNull, and put the value in this OpenBalance field if not isNull....?
Thanks
Mr. Stumped