Form with SubForm

[njload]

I have an Orders form with a subform with the products, price ext price tax etc. On the bottom of the subform it will not total the subform information example =sum([ExtPrice]) will not return a value it's blank. take away the =sum and just put in [ExtPrice] and the value shows up but not totaled.

using access 2010

 

[bob fitz]

Not sure about this but if [ExtPrice] is a calculation (something like [Qty] * [Price]), you my need to show that in the Sum() eg: Something like = Sum([Qty] * [Price])

 

[njload]

Bob thanks for the reply but it's not the case. Interesting twist though is it works in Access 2003 but when I bring it over to 2010 it dosen't.

 

[bob fitz]

I don't think I can help you with anything in A2010 because I have no experience with that version (I use A2000 and A2003). Which expression works in A2003.