Need help with a Form that will provide UPS shipping charges

[puebla1]

In MS Access 2000, I am trying to make a form that will identify shipping cost using the UPS spreadsheet for shipping costs by weight and zone. Their first column is the package weight amount, the next 10 columns are the zones with the shipping charges. If you know the zone, which is done fairly easily, the cost is cross referenced by using the weight and the zone #. I want to be able to enter the package weight and zone # and have the shipping cost returned. Is this possible?

 

[dhookom]

Please think in terms of a table of charges and what the fields and typical data look like. Provide this information with how you want to use the data.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Howare ya puebla1 . . .

Can you provide a link for this [blue] UPS SpreadSheet[/blue]?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[puebla1]

Hi Guys, thanks for responding! I have attached the link where UPS provides the spreadsheet. I am looking at daily rates - US Ground Shipping Rates.