SUM not working in form (1 Viewer)

[thudson]

This should work, but doesn't:banghead:

=[Total Costs]*[Qty],<<< this extends the the line total

=Sum([Total Costs]*[Qty]), <<<this should add up all of the line totals.

The Total Costs*Qty Text box is called 'LineTotal', so I also tried Sum([LineTotal]).
Both don't work.
Can't see whats wrong!
Can anyone see where I'm going wrong?

 

[missinglinq]

Is [Total Costs] an entered value...or is it also Calculated from other Controls? It sounds like the latter, given its name.

If it is Calculated, you need to use that Expression times QTY.

Linq ;0)>

 

[arnelgp]

you put your Grand Total unbound textbox to the Form's Footer Section.

 

[thudson]

Don't know what was going on, but I had saved the changes several times as I changed the formula. I reopened the database after closing it and voila it calculated the total. I was tearing my hair out (haven't got much now), was getting frustrated after looking at this for an hour or more!