Subform total is not working on Main form

[Sunnylei]

Hi
I created a subform which contains a total field for cost of each item. The total

= [Quantity]*[UnitPrice]*(1-[Discount]/100)

. The subform name is subfPurchaseOrders
I also created unbound Total cost which Sum up all items cost at subform footer

 Total Cost = Sum([Total])

I'm trying to display it on Main Form. I created one more unbound Total Cost in Main Form

 [subfPurchaseOrder].[Form]![TotalCost]

But it does not display anything on Main Form.
Can anyone help?

 

[Ari]

Hi

It is not possible sum fields disconnected from the query/table.

Try this:

Total Cost = Sum([Quantity]*[UnitPrice]*(1-[Discount]/100))


Success!

 

[missinglinq]

You cannot use an Aggregate Function, such as Sum() against a Calculated Field.

If, for instance, you have

FieldC = FieldA * FieldB

you cannot use

Sum(FieldC)

you have to use

Sum(FieldA * FieldB)

Also note that you have to be using the Field names here, not the name of the Controls on the Form that displays the Fields. Sometimes the two have identical names (that's how it's assigned them if you leave it to the Access Gnomes) and sometimes they're not.

Linq ;0)>

 

[Sunnylei]

Hi

It is not possible sum fields disconnected from the query/table.

Try this:

Total Cost = Sum([Quantity]*[UnitPrice]*(1-[Discount]/100))


Success!

It's down. Thanks

 

[missinglinq]

Glad we could help!

Linq ;0)>