AlvaroCity
Registered User.
- Local time
- Today, 11:10
- Joined
- Jul 16, 2016
- Messages
- 70
Hey folks!
I bumped into a problem on my database.
I've got a query which says either a invoice is completely paid off or not. The thing is that in my query I have a field called "Total" and another one called "AmountPaid" and I created another which turns out either the "AmountPaid" is greater than "Total" to check if the invoice has been paid off as shown:
The problem is that sometimes the "amountpaid" is not greater than "total"(so the invoice hasn't been paid off) and the query displays "Yes" :banghead:
Why is this??
Thank you in advance.
I bumped into a problem on my database.
I've got a query which says either a invoice is completely paid off or not. The thing is that in my query I have a field called "Total" and another one called "AmountPaid" and I created another which turns out either the "AmountPaid" is greater than "Total" to check if the invoice has been paid off as shown:
Code:
PaidOff: SiInm([AmountPaid]<[Total];"No";"Yes")
The problem is that sometimes the "amountpaid" is not greater than "total"(so the invoice hasn't been paid off) and the query displays "Yes" :banghead:
Why is this??
Thank you in advance.