In a Report, How to Sum a calculated field which (itself) sums up a field in a table. This calculated field (on which I want to set calculation) is created by another query.
Can I use this formula in Report Footer?
=SUM (SumOfExtendedPrice)
Or should I refer to the name of the TextBox of this field on Report? for example:
=SUM (txtSumOfExtendedPrice)