Full Version: Calculated Unbound Field Flashes #error
UtterAccess Forums > Microsoft® Access > Access Forms
TimTDP
On a subform I have an unbound field, called TotalValue, =[Quantity] * [Price]
In the footer of the subform I have another unbound field, called SumTotalValue, = Sum([Quantity] * [Price])
If I change records on the main form the unbound field called SumTotalValue sometimes flashes "#Error"
This happens even if the fields [Quantity] & [Price] have valid entries.
I have tried requerying the subform and the unbound field SumTotalValue but this does not help
What else should I try?
mike60smart
Hi
You say :-
On a subform I have an unbound field, called TotalValue, =[Quantity] * [Price]
In the footer of the subform I have another unbound field, called SumTotalValue, = Sum([Quantity] * [Price])
If you create a query for the fields you need on the subform and create a new Calculated field in the query called:-
Total:[quantity]*[price]
Then in the subform footer you can reference this by using = Sum([Total]
TimTDP
Great minds think alike!!!
I have just done this and it works perfectly!
Many thanks for the reply
mike60smart
Hi
Glad to help
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.