Is it possible to use access calculate freight costs

[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

 

[Wayne-I-M]

Hi

Yes you can do this this in access but this seems to be just the sort of
thing excell was designed for.

This said using MS Office to run anything with over 20k actions per week
seems (to me) to be slightly over the top. I know access and excell can
simply handle the volumn but you may want to look a bespoke sql application
for this.

 

[whnkee]

Hi

Yes you can do this this in access but this seems to be just the sort of
thing excell was designed for.

This said using MS Office to run anything with over 20k actions per week
seems (to me) to be slightly over the top. I know access and excell can
simply handle the volumn but you may want to look a bespoke sql application
for this.

--
Wayne
Manchester, England.







- Show quoted text -

Yes, actually I am doing this Excel at the moment using the formula
like "if" and "index" functions to retrieve the freight rate to do the
calculation. But the problem is the volume as the consignemts number
is going up quickly and I can't put monthly data in one file. Can you
please give more clue as to how to do this in Access as I am very new
to Access

Thanks

 

[Douglas J. Steele]

Sorry to disagree, Wayne, but I see no reason why it would be better to do
this in Excel.

Tom Ellison gives a good example of how to do this using Access, hosted by
Allen Browne at http://www.allenbrowne.com/ser-58.html

 

[whnkee]

Sorry to disagree, Wayne, but I see no reason why it would be better to do
this in Excel.

Tom Ellison gives a good example of how to do this using Access, hosted by
Allen Browne athttp://www.allenbrowne.com/ser-58.html

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)









- Show quoted text -

The link seems can solve second half of the problem like select the
value from the range of weight, but how to solve the fist half of the
problem to apply the "from" and "to " factors to retrieve the charge?

 

[Douglas J. Steele]

I don't see how the first is any different than the second!