tinyevil777
Registered User.
- Local time
- Today, 09:00
- Joined
- Dec 10, 2010
- Messages
- 137
Hey there,
My query validates the Total from the Hold table against the Total from the grn table. I've got this working fine using
I want to now add an allowance of (lets say) £1.00 either side of the Total.
i.e.
If a total in Hold is £25.00, and the total for the same OrderNo in grn is £24.01 or £25.99, it will NOT flag up. However, if the total in grn is £26.01, then it would action the query.
What code/criteria would i need to use to do this?
I'm the first to use a trial and error method, but i'm really at a loss where to begin with this.
Thank you in advance!
Tom
My query validates the Total from the Hold table against the Total from the grn table. I've got this working fine using
Code:
<>[grn]![Total]
i.e.
If a total in Hold is £25.00, and the total for the same OrderNo in grn is £24.01 or £25.99, it will NOT flag up. However, if the total in grn is £26.01, then it would action the query.
What code/criteria would i need to use to do this?
I'm the first to use a trial and error method, but i'm really at a loss where to begin with this.
Thank you in advance!
Tom