A
Annie
Hi
I am having a huge problem trying to get a total of 2 subforms in one main
form.
Example:
My main form is created from a Table and has info on products and in this
form I have brought in a subform as follows:
Product Code Qty Price
1 2 500
2 3 600
I have added a total field to the subform to allow the Qty x price :
Product Code Qty Price Total
1 2 500 1000
2 3 600 1800
I have a second subform with other product info set up the same way as above
Subform 1 is for kitchen details - subform 2 is for wardrobe details.
I would like to have the total of the totals for the first subform and then
add this to the total of the totals for the 2nd subform. At the moment I
have :
Product Code Qty Price Total Grand Total
1 2 500 1000 2800
2 3 600 1800 2800
I just added the Grand total on to both of the subforms =sum[Total]
I noticed that the Grand Total gives me a total on every line - I can live
with this but how can I add the 2 Grand Totals together in my main form??
Please help before I completely lose it and give in!!!
Many thanks and kind regards
Kind regards
Ann Shaw
I am having a huge problem trying to get a total of 2 subforms in one main
form.
Example:
My main form is created from a Table and has info on products and in this
form I have brought in a subform as follows:
Product Code Qty Price
1 2 500
2 3 600
I have added a total field to the subform to allow the Qty x price :
Product Code Qty Price Total
1 2 500 1000
2 3 600 1800
I have a second subform with other product info set up the same way as above
Subform 1 is for kitchen details - subform 2 is for wardrobe details.
I would like to have the total of the totals for the first subform and then
add this to the total of the totals for the 2nd subform. At the moment I
have :
Product Code Qty Price Total Grand Total
1 2 500 1000 2800
2 3 600 1800 2800
I just added the Grand total on to both of the subforms =sum[Total]
I noticed that the Grand Total gives me a total on every line - I can live
with this but how can I add the 2 Grand Totals together in my main form??
Please help before I completely lose it and give in!!!
Many thanks and kind regards
Kind regards
Ann Shaw