robinsonbst
New member
- Local time
- Today, 18:17
- Joined
- Aug 19, 2005
- Messages
- 8
Hi Again
Thanks for all the help previously to the guys that helped me last time if they read this.
My question is i am trying to setup an POS system on my laptop so that i can print invoices from it so i am trying to calculate totals from the sub datasheets that i have inserted into my form.
I am using a relationship between the tables so that the linking field is the invoice number.
Now as i fill in the details of what the customer has ordered in the sub datasheet i would like a total displayed in the main form where the customer details are located, currently at the moment i am using this code in the total box at the top of the page.
=Sum([InvoiceDetails subform].[Form]![Text14])
Text14 being the running totals for each of the items the customer purchases, for example if they purchase 10 of one item at £5 and 5 of another at £7, the totals for the first item and the totals for the second item are calculated in this field.
This is the field i need adding together line by line i.e Total of (£5 x 10=£50)+(£7 x 5=£35)+(etc......)+(etc......) and then displayed in the main form in the grand total box.
Any help would be appreciated.
Thanks for all the help previously to the guys that helped me last time if they read this.
My question is i am trying to setup an POS system on my laptop so that i can print invoices from it so i am trying to calculate totals from the sub datasheets that i have inserted into my form.
I am using a relationship between the tables so that the linking field is the invoice number.
Now as i fill in the details of what the customer has ordered in the sub datasheet i would like a total displayed in the main form where the customer details are located, currently at the moment i am using this code in the total box at the top of the page.
=Sum([InvoiceDetails subform].[Form]![Text14])
Text14 being the running totals for each of the items the customer purchases, for example if they purchase 10 of one item at £5 and 5 of another at £7, the totals for the first item and the totals for the second item are calculated in this field.
This is the field i need adding together line by line i.e Total of (£5 x 10=£50)+(£7 x 5=£35)+(etc......)+(etc......) and then displayed in the main form in the grand total box.
Any help would be appreciated.
