FORMULA - ACCESS

S

SLOPES

Can some help me with formula. i have three tables - there is more than 1
answer
table 1 - page
table 2 - rates - zone i send it to


i need to figure out based on qty ordered which table will give me the right
rates and there are limits based on table

check qty ordered - find and tell me page - then break up the limits by zone
* more than one answer returned - show better zone ( one with ***)

page max qty page max qty
table 1 - 305 5 L or 307 60 L

table 2
page max qty zone 1 zone 2 zone 3 zone 4
305 5 1 5 5 5
307 60 2.5 5 10 10

for example - if qty ordered is 5 L
Then answer would be
page 305 - if zone 1 - i need - 5 x 1 L - 1 box
*** page 305 - if zone 2 - 4 - i need - 1 x 5 L - 1 box

for example - if qty ordered is 20 L
Then answer would be
page 305 - if zone 1 - i need - 5 x 1 L - 4 separate
page 305 - if zone 2 - 4 - i need - 1 x 5 L - 4 separate
page 307 - if zone 1 - i need - 8 x 2.5 L - 1 box
page 307 - if zone 2- i need - 4 x 5 L - 1 box
*** page 307 - if zone 3 - 4 - i need - 2 x 10 L - 1 box
 
Top