Active/Inactive 1

[ryshkus]

Hello,

I am trying to figure out how to do something with our accounting DB. We bill a customer. They pay a certain amount less than what billed. I need to take 3 fields and if they equal the write off amount billed field then I want them to go to inactive status.

This is what I have and it prompts me to enter the amt billed....

IIf(IsNull([W/O_Amt]-[Amt_paid]-[Later_pay]=[ Amt_billed]),"Inactive")

 

[PHV]

Follow the Report wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244