I have a querry "Refund" that should calculate the persons refund that is due to them. The querry is created from several tables. It has the following fields:
ID, Name, Address Info (broken down of course), Ship Info, PmtType, PmtAmt, InvTotal, Total, Refund
I have cretieria in the PmtAmount Section which is: >[Total]
PmtAmt= The amount the customer paid
InvTotal is the total on their invoice (not including tax)
Total is Their Invoice Total plus Tax. I had to put "Total" as an expression in the underlying querry because the invoice total includes shipping and we can only charge tax on the actual items. The refund should be [PmtAmt]-[Total]
1) If I put the criteria ">0.00" in the Refund field on the querry, it still spits out those with a $0.00 refund.
2) When I created a report, the numbers are getting changed on those in the state of Virginia (as that is the only state that must pay tax)
HELP!!!!
Who's Who
ID, Name, Address Info (broken down of course), Ship Info, PmtType, PmtAmt, InvTotal, Total, Refund
I have cretieria in the PmtAmount Section which is: >[Total]
PmtAmt= The amount the customer paid
InvTotal is the total on their invoice (not including tax)
Total is Their Invoice Total plus Tax. I had to put "Total" as an expression in the underlying querry because the invoice total includes shipping and we can only charge tax on the actual items. The refund should be [PmtAmt]-[Total]
1) If I put the criteria ">0.00" in the Refund field on the querry, it still spits out those with a $0.00 refund.
2) When I created a report, the numbers are getting changed on those in the state of Virginia (as that is the only state that must pay tax)
HELP!!!!
Who's Who
. This will get rid of fractions of pennies. That is probably why you are getting records for ">0.00" as "0.001>0.00" but is begin displayed as "0.00" in your query view.