Order Form Pasting Data into table

[KenshiroUK]

Okay I have an Orders Form, which generates a SubTotal Price (ex VAT), VAT, Shipping & Freight Charge based on an IIF statment of being under a £50.00 order apply £20.00 charge. And finally a Order Total with it all added together. This works fine, however I cannot seem to find a way to post these prices in my Orders Table. When I click on Datasheet View for the form, all the details appear as they should. I'm a little stuck here on how to get those details into my Orders Table.

 

[KenshiroUK]

Would I need an SQL code, or is there a VB or query to add that data into the table?

 

[missinglinq]

...how to get those details into my Orders Table...

If you're talking about having Calculated Values (which is my reading on this) stored in your Table, the answer is that you don't! Most Calculated Values (and certainly these) should not be stored, but simply re-calculated, as needed, for Reports, other Forms, etc.

Linq ;0)>

 

[KenshiroUK]

Adding Order Form Data into table

I've posted a copy of my DB but yes the prices in the last four fields are SUMs based on the Subtotal (not including VAT). But for me to print out a Depatch Note and Invoice I need those prices stored in the orders table.