Ruhi
Yes/No fields are not null. They are either 0 or -1. Your calculation should be:
=IIf([NotPaid]=0,0,[DebtQuantity]*0,05)
--- In ms_access_professionals@yahoogroups.com, <no_reply@yahoogroups.com> wrote:
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
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 (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar