Sum a found set of records

[paperbag1]

When I find a set of records, I receive a list, each of which has an order total(also the field name) in it. I want to sum the order totals for the entire found set. I have created a field called Grand Total, made it a calculated field, and used the formula "Unstored=Sum ( Order Total )". Well guess what... this doesn't work. This should be simple, but I don't have a clue. What am I doing wrong?

Thanks,

Phil

[Ender]

Try a summary field instead. Sum() works on related values, repeating fields, and a list of numbers, summary fields work on found sets.

[paperbag1]

See, I told you it should be simple. The only thing more simple is ME. Thanks for the help.

Phil