I am developing a database to track my eBay sales and I have written an expression to work out the cost for International postage, based on the zone they are in. I have decided to display 2 different text boxes for the 2 postage zones.
The cost is determined based on the weight.
Here is the expression I have written:
IIf( [International Zone] =1 And [Weight g] Between 0 And 100 ,3.30,
IIf( [International Zone] = 1 And [Weight g] Between 101 And 250 ,4.85,
IIf( [International Zone] = 1 And [Weight g] Between 251 And 500,7.10 ,
IIf( [International Zone] = 1 And [Weight g] Between 501 And 750 , 9.15,0))))
It does not error but does not give the correct answer.
Lets say the weight is 150 and the zone is 1. the answer should be 4.85, but it gives 0.
I have checked on the web and the logic is correct.
In the table the Zone and Zone Cost are general numbers.
Can any one see where I am going wrong?