davidchipman
Programmer
Hi All
Hoping that someone can help me.
I am creating a report from a query.
My 2 columns in question include Unpaid Balance and Type of charge. The type of charge includes Invoices and Interest and the Unpaid Balance is simply the amount owing on these charges. I am trying to do a report that subtracts the Invoice from the Interest. What I am trying to do is do something in this report that says If Unpaid Balance is an Interest charge, make it negative. Then i can simply get a sum of the 2 numbers. If anyone knows how i can do this it would be appreciated. Thanks and Happy Holidays.
dave
Hoping that someone can help me.
I am creating a report from a query.
My 2 columns in question include Unpaid Balance and Type of charge. The type of charge includes Invoices and Interest and the Unpaid Balance is simply the amount owing on these charges. I am trying to do a report that subtracts the Invoice from the Interest. What I am trying to do is do something in this report that says If Unpaid Balance is an Interest charge, make it negative. Then i can simply get a sum of the 2 numbers. If anyone knows how i can do this it would be appreciated. Thanks and Happy Holidays.
dave
