Form To Calculate The Fines ....

[Milade8080]

Hi
I need a form to calculate the fines as follows:


TXTBOX1 ---> Specified date to pay taxes


TXTBOX2 ---> Amount of tax
TXTBOX3 ---> Date on which the tax is paid
TXTBOX4 ---> The amount paid for taxes
TXTBOX5 ---> Calculation Date
Txt Box6 ---> Amount of fines
--------------------------------------------------------------
IF (TXTBOX1>=TXTBOX3) And (TXTBOX4=TXTBOX2) --> Txt Box6= 0
IF (TXTBOX1>=TXTBOX3) And (TXTBOX4<TXTBOX2) --> Txt Box6= (TXTBOX2-TXTBOX4)*0.02* distance between two dates TXTBOX1 and TXTBOX5 by month
IF (TXTBOX1<TXTBOX3) And (TXTBOX4=TXTBOX2) --> Txt Box6= (TXTBOX2*0.02* distance between two dates TXTBOX1 and TXTBOX3 by month
IF (TXTBOX1<TXTBOX3) And (TXTBOX4<TXTBOX2) --> Txt Box6= (TXTBOX2*0.02* distance between two dates TXTBOX1 and TXTBOX3 by month
+ (TXTBOX2-TXTBOX4)*0.02* distance between two dates TXTBOX3 and TXTBOX5 by month

[June7]

You are showing Excel syntax for If() function. In Access it would be:

IIf(this condition true, do this, else do this)

As one example using your info, something like this in ControlSource property of TXTBOX6:

=IIf(TXTBOX1 >= TXTBOX3 AND TXTBOX4 = TXTBOX2, 0, do something else)

Should be able to nest up to 7 IIf() levels.

[Milade8080]

Thanks
you can build this form for me???


TXTBOX1 ---> Specified date to pay taxes
TXTBOX2 ---> Amount of tax
TXTBOX3 ---> Date on which the tax is paid
TXTBOX4 ---> The amount paid for taxes
TXTBOX5 ---> Calculation Date
Txt Box6 ---> Amount of fines
--------------------------------------------------------------
IF (TXTBOX1>=TXTBOX3) And (TXTBOX4=TXTBOX2) --> Txt Box6= 0
IF (TXTBOX1>=TXTBOX3) And (TXTBOX4<TXTBOX2) --> Txt Box6= (TXTBOX2-TXTBOX4)*0.02* distance between two dates TXTBOX1 and TXTBOX5 by month
IF (TXTBOX1<TXTBOX3) And (TXTBOX4=TXTBOX2) --> Txt Box6= (TXTBOX2*0.02* distance between two dates TXTBOX1 and TXTBOX3 by month
IF (TXTBOX1<TXTBOX3) And (TXTBOX4<TXTBOX2) --> Txt Box6= (TXTBOX2*0.02* distance between two dates TXTBOX1 and TXTBOX3 by month
+ (TXTBOX2-TXTBOX4)*0.02* distance between two dates TXTBOX3 and TXTBOX5 by month

[June7]

No, I cannot build for you. You can build and post your attempts for analysis.

[ssanfu]

Hint.......

For this part of the calculation:
distance between two dates TXTBOX1 and TXTBOX5 by month

use the DateDiff() function....