Total On Order Form and Invoice

[BobMcL]

Hi, im trying to add a total to my order form but i am finding it a bit tricky, but once i have done this i also need to create an invoice, which should be simple enough but is quite difficult because of the way the system has been put together. Any help is appriciated, but please keep it simple, thanks, bob.

Here is my system as a zip:
Gamez System

 

[Rickster57]

total

In your query qry sales create a field called atotal. Where atotal:[quantity]*[price]

Set your your data property of atotal field on your frm sales form to atotal from the query. In the footer of this form place a text box called text72 and set it's data to sum([atotal]). This will add your totals up.

Then in the Invoice form where you have your text box called text67 place the following in your data property:
=[Forms]![order form]![order subform].Form!text72

Looks like your off to a good start!!

 

[alastair69]

Quick Question is your send date the same as ship date, or do you need an extra field adding with send date?

Alastair

 

[alastair69]

Its ok i have figuard it out, the ship date is the same as your refereced send date

 

[alastair69]

A quick comment on your database are you going to have a cost for the delivery to add to your prices. If you could let me know i will add it to the database, i am currently going though and comment on the tables and querys as what information is pulled from where. If you could suply me with your e-mail address so i can send you the database.

Alastair