Form Subtotals & Grand Total

[queenbean84]

I am new to designing forms in Access. For the attached form, I have two tables, one for the header info at the top and another for the detail. I want to add the fields for sales tax, shipping, and total at the bottom. Which table should these fields be in? Do they need to be in both tables? Also, I'd like to add a total line below the purchase order detail items. How do I do that?

[CJ_London]

How do I add a total line here?

change the subform to a continuous form, not a datasheet and put the totals in the form footer

In what table do I put these fields?

shipping - in the purchase order table (it is only applied once).
Tax Paid - in the purchase detail table (tax is calculated on each row) On the main form it is an unbound control which sums the tax paid calculated on the subform
Total Purchase - not stored in any table but calculated as required (sums the subform plus shipping)

[queenbean84]

Thank you, I'll do that!

[queenbean84]

If I change the subform to a continuous form, will I be able to add more than one product?

[CJ_London]

yes - just line your controls up in a single row with the labels over them in the header section.

If you are not sure, use the wizard to create a continuous form (it is also called a multiple items form) Create>More Forms>Muliple items