A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Total of Subform



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2008, 01:54 PM posted to microsoft.public.access.formscoding,microsoft.public.access.forms
Microsoft[_18_]
external usenet poster
 
Posts: 33
Default Total of Subform

Access 2007

I have a mainform which contains a subform

The mainform contains details of the finished item
the subform contains details of the finished items parts

Eg
Main form = Table = sum of 4 x 10 + 1 x 140 = £198
Subform = 4 x legs @ £10ea + 10% markup
1 x top @ £140 ea + 10% markup

I would like the mainform to have a running total of how much the item is
costing as new lines are added to the subform.

Subform contains
Itemdesc
ItemQty
ItemUnitRate
ItemMarkUp%
ItemSaleValue - this is a calculated field ......
=(ItemQty*ItemUnitRate)+(ItemQty*ItemUnitRate*Item MarkUp%)

Mainform contains
FinItemDesc
FinItemQty
FinItemSalValue - it is this field that I cannot calculate. I want it to
equal Sum(ItemSalValue) * FinItemQty

I have tried adding a calculated field in the footer (txtItemTotal) of the
subform as: sum(ItemSaleValue)
and a calculated field in the mainform as: forms!frmSubform.txtItemTotal x
FinItemQty

but this doesn't work.

What am I doing wrong

Thanks

A


  #2  
Old May 6th, 2008, 02:01 PM posted to microsoft.public.access.formscoding,microsoft.public.access.forms
Microsoft[_18_]
external usenet poster
 
Posts: 33
Default Total of Subform

The subform itself doesn't show the correct total either - it just has
#error
"Microsoft" wrote in message
...
Access 2007

I have a mainform which contains a subform

The mainform contains details of the finished item
the subform contains details of the finished items parts

Eg
Main form = Table = sum of 4 x 10 + 1 x 140 = £198
Subform = 4 x legs @ £10ea + 10% markup
1 x top @ £140 ea + 10% markup

I would like the mainform to have a running total of how much the item is
costing as new lines are added to the subform.

Subform contains
Itemdesc
ItemQty
ItemUnitRate
ItemMarkUp%
ItemSaleValue - this is a calculated field ......
=(ItemQty*ItemUnitRate)+(ItemQty*ItemUnitRate*Item MarkUp%)

Mainform contains
FinItemDesc
FinItemQty
FinItemSalValue - it is this field that I cannot calculate. I want it
to equal Sum(ItemSalValue) * FinItemQty

I have tried adding a calculated field in the footer (txtItemTotal) of the
subform as: sum(ItemSaleValue)
and a calculated field in the mainform as: forms!frmSubform.txtItemTotal
x FinItemQty

but this doesn't work.

What am I doing wrong

Thanks

A



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.