Ruhi-
A Yes/No field is either 0 or -1. Try this:
=Abs([NotPaid] * ([DebtQuantity] * 0.05))
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rkulez
Sent: Friday, September 20, 2013 12:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Calculation of a control in a report
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 (3) |
Tidak ada komentar:
Posting Komentar