Re: Calculations based on other field values
- From: "Ed Robichaud" <edrobichaud@xxxxxxx>
- Date: Thu, 30 Aug 2007 23:13:28 -0400
How about just displaying the calculated postage (based on user input of
weight and # of pieces) for all classes - first class, flats, parcel,
priority and express, etc. This could be done with either calculated
controls or lookup tables of rates (easier to maintain for rate changes).
-Ed
<LesYeuxBrass@xxxxxxxxx> wrote in message
news:1188508226.741078.290360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm producing a database to calculate projected costs of our mailings
in-house and am trying to introduce a formula which will determine
what postage to apply based on envelope size and weight.
I have two tables providing data for this -
Table A contains information about the mailing itself, weight, number
of recipients, etc.
Table B contains information about the type of packaging - small,
medium or large envelopes
On the form, the User selects the size of envelope and it plugs in
data in a hidden field that provides a "base rate" (the number of
packages that can be assembled in an hour) which helps determine how
long a mailing will take.
The postage is different based on size of envelope and weight by each
size. Small has two weight classes, medium has 3, and large is
prorated by weight over a certain amount. I've created a formula for
each package size that will provide the required information but I
can't get the form to use it when I select an envelope size.
What I envision -
User selects size of envelope
Base Rate updates with the estimated value
Postage field automatically updates with the appropriate formula
related to envelope size
Formula calculates which price to use based on weight of each package.
Any suggestions are greatly appreciated.
Steven
.
- References:
- Calculations based on other field values
- From: LesYeuxBrass
- Calculations based on other field values
- Prev by Date: Re: strangest hanging problem with re-attaching functions...
- Next by Date: Re: Open external help file
- Previous by thread: Calculations based on other field values
- Next by thread: Re: Calculations based on other field values
- Index(es):
Relevant Pages
|
