Calculating a field

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000 - I have a form that our shipping dept. uses when an item is
shipped. They enter quantity shipped, weight, tracking number and freight
charge. The freight charge is what is passed on from the shipping company -
UPS, FEDEX, etc. We also charge $1.25 for each box that is used to ship our
product, which is currently be added into the freight charge.

1) I would like to have a seperate field which the user will enter the
number of boxes used. From that entry, the number of cartons will be
multiplied by $1.25 to provide the box charge.

2) With the freight charge, if the items are shipped either "freight
collect" or "CBS" - (where the consignee is being billed) the freight charge
would be $0.00. In all other cases, we would pass the freight charge on to
the customer. Is it possible to only allow those shipments that are not F/C
or CBS to have a freight charge to be entered and F/C & CBS to stay at
$0.00?

Currently, the fields go to a table which also calculates a monthly invoice.

If you need more information, please feel free in asking. Thanks in advance
for your help.
 
To confirm you have a form textbox in which the user
enters a number of boxes, I'll call it txt_Boxes. There
is also a checkbox field that indicates if the client is
CBS, called chk_CBS. Finally we have a textbox called
txt_FreightCharge which shows how much the charge is.

In the after update even of the textbox txt_Boxes use the
following:

If chk_CBS = True Then
txt_FreightCharge = txt_FreighCharge + (txt_Boxes * 1.25)
End If

this procedure will add the current freight charge, if
there is any with the result of the second charge only if
the client is CBS
 
Back
Top