Dear memnbers and pros,
I have a db made with msaccess 2003. Altough it is much more complex I want to simplify my problem:
I have a table of customers with Customer_ID,Name,DebtQuantity,NotPaid fields. The last field is a yes/no type and it shows if the debt is paid at the end of a month. If he customer don't pay it at the end of the month we increase the debt %5. I prepare a report at the end of the month including the fields in the table and want to show the increase of the debt . In my report's DebtDelayİncrement control I use the formula:=IIf(IsNull([NotPaid]),0,([ DebtQuantity])*0,05). This formula works for calculating but it increases all the customers debts even only one customers "not paid" is yes. I wish it to increase debt of customers which is NotPaid=yes. I couldn't figured it out. Is it a wrong way to use yes/no field in the table in this situation? Can you please show me a way? Thanks in advance.
Ruhi Kulez
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar