How would I add "shipping charge" to an Invoice (form/subform) ?

[mthornblad]

Hi

I have an "Invoice" form/subform for entering customer invoice data.
I need to add a "shipping charge" field. Sounds easy but I have a
problem with the concept.

I enter a customer number in the main form and based on the
relationships, all the customer data is automatically displayed. I
then enter each line item of the invoice in the subform and calculate
a running subtotal for the invoice. After I enter all of the invoice
line items, I need to enter the shipping amount and capture it so I
can calculate the total invoice amount later.

I guess my question is: Where do I put the shipping charge control if
I want to enter it after I enter all of the line items ?

I hope this makes sense.

I would appreciate any help.

Thanks
Mark

 

[Guest]

In the footer of the subform.

=sum([field])

will give you the total of a "field". I would presume

=sum([field])*0.05

will give you 5% of the total.

 

[BruceM]

If the shipping charge is a fixed price you could just have it as one of
your items, as if it was a product. If it is based on the invoice total or
other such criteria you can calculate it in the footer. The most flexible
choice is probably to include such information in the main form. You can
use an unbound text box (txtSubtotal) to get information from the subform:
=Forms!frmMain!SubformName.Form!txtSubtotal (where txtSubtotal is the
calculated subtotal from the subform footer).
In another text box you could have the Shipping field. A third (unbound)
text box could add the two together:
=[TextBoxName] + [Shipping]
Remember that you do not need to store this value. Just calculate it as
needed.

 

[mthornblad]

If the shipping charge is a fixed price you could just have it as one of
your items, as if it was a product. If it is based on the invoice total or
other such criteria you can calculate it in the footer. The most flexible
choice is probably to include such information in the main form. You can
use an unbound text box (txtSubtotal) to get information from the subform:
=Forms!frmMain!SubformName.Form!txtSubtotal (where txtSubtotal is the
calculated subtotal from the subform footer).
In another text box you could have the Shipping field. A third (unbound)
text box could add the two together:
=[TextBoxName] + [Shipping]
Remember that you do not need to store this value. Just calculate it as
needed.

Hi

I have an "Invoice" form/subform for entering customer invoice data.
I need to add a "shipping charge" field. Sounds easy but I have a
problem with the concept.

I enter a customer number in the main form and based on the
relationships, all the customer data is automatically displayed. I
then enter each line item of the invoice in the subform and calculate
a running subtotal for the invoice. After I enter all of the invoice
line items, I need to enter the shipping amount and capture it so I
can calculate the total invoice amount later.

I guess my question is: Where do I put the shipping charge control if
I want to enter it after I enter all of the line items ?

I hope this makes sense.

I would appreciate any help.

Thanks
Mark

Thanks

I'll experiment and try to find the best way.

I appreciate your help.

Mark

 

[BruceM]

The Northwinds sample database that ships with Access has an Orders form
that illustrates the third option I mentioned.

If the shipping charge is a fixed price you could just have it as one of
your items, as if it was a product. If it is based on the invoice total
or
other such criteria you can calculate it in the footer. The most
flexible
choice is probably to include such information in the main form. You can
use an unbound text box (txtSubtotal) to get information from the
subform:
=Forms!frmMain!SubformName.Form!txtSubtotal (where txtSubtotal is the
calculated subtotal from the subform footer).
In another text box you could have the Shipping field. A third (unbound)
text box could add the two together:
=[TextBoxName] + [Shipping]
Remember that you do not need to store this value. Just calculate it as
needed.

Hi

I have an "Invoice" form/subform for entering customer invoice data.
I need to add a "shipping charge" field. Sounds easy but I have a
problem with the concept.

I enter a customer number in the main form and based on the
relationships, all the customer data is automatically displayed. I
then enter each line item of the invoice in the subform and calculate
a running subtotal for the invoice. After I enter all of the invoice
line items, I need to enter the shipping amount and capture it so I
can calculate the total invoice amount later.

I guess my question is: Where do I put the shipping charge control if
I want to enter it after I enter all of the line items ?

I hope this makes sense.

I would appreciate any help.

Thanks
Mark

Thanks

I'll experiment and try to find the best way.

I appreciate your help.

Mark