hi , somebody help me with this little bit of calculation in access , am not
able to work out . i have 4 fields on a form , its like this , TOTAL ,
AMOUNTPAID , CREDIT , DEBIT.
now getting CREDIT by TOTAL - AMOUNTPAID is easy but incase the 2nd value
is greater the CREDIT value is shown as negative , what i want is to have
that value in debit field . seems easy but i just dont get it .
thanx

Private Sub AmountPaid_LostFocus()
If Total.Value - AmountPaid.Value = 0 Then
Debit.Value = 0
Credit.Value = 0
Else
If Total.Value - AmountPaid.Value > 0 Then
Debit.Value = Total.Value - AmountPaid.Value
Credit = 0
Else
Credit.Value = AmountPaid.Value - Total.Value
Debit.Value = 0
End If
End If
End Sub

Private Sub Form_Load()
Total = Null
AmountPaid = Null
Credit = Null
Debit = Null
End Sub

Private Sub Total_LostFocus()
If Total.Value - AmountPaid.Value = 0 Then
Debit.Value = 0
Credit.Value = 0
Else
If Total.Value - AmountPaid.Value > 0 Then
Debit.Value = Total.Value - AmountPaid.Value
Credit = 0
Else
Credit.Value = AmountPaid.Value - Total.Value
Debit.Value = 0
End If
End If
End Sub

"Lancer" <neur0lancer (AT) hotmail (DOT) com> wrote

How about:

Credit : IIF(([Total]-[AmountPaid])>0,[Total]-[AmountPaid], Null)

Debit : IIF(([Total]-[AmountPaid])<0,[Total]-[AmountPaid], Null)

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

"Lancer" <neur0lancer (AT) hotmail (DOT) com> wrote

thanx , both the methods work fine

"What-a-Tool" <Die!FrigginSpammersDieDie!@NoShitSherlock.Net> wrote