Ok, dunno how much sense this is gonna make but i will try so please bear with me:
I have a query which has 4 fields in it.
They are labelled:
ToleranceBottom (is the Total-5%)
ToleranceTop (Is the Total +5%)
I need a new field that clearly defines to me the following:
Where the Total is less than or equal to ToleranceBottom, i need a "1"
Where the Total is more than or equal to ToleranceTop, i need a "2"
Where the Total is between the ToleranceTop and ToleranceBottom, i need a "0"