W
whnkee
I need to audit the freight bills charged by freight company which has
over 20,000 consignment per week. The basic charge is base on distance
and weight, something like this:
SYD-MEL <1kg $6
SYD-MEL<3kg $6.7
SYD-MEL<5kg $7
SYD-MEL<10kg$10
SYD-MEL>=10kg $12, $4 per kg rate
SYD-PER<1kg $10
......
Based on the freight rate, how can I use Access to calculate the
freight charge for each of the consignment ? Is there anyway to build
some query or something to retrieve the freight rate and calculate the
freight cost of each consignment?
Thanks
over 20,000 consignment per week. The basic charge is base on distance
and weight, something like this:
SYD-MEL <1kg $6
SYD-MEL<3kg $6.7
SYD-MEL<5kg $7
SYD-MEL<10kg$10
SYD-MEL>=10kg $12, $4 per kg rate
SYD-PER<1kg $10
......
Based on the freight rate, how can I use Access to calculate the
freight charge for each of the consignment ? Is there anyway to build
some query or something to retrieve the freight rate and calculate the
freight cost of each consignment?
Thanks