Total amout

  • Thread starter Thread starter Mavis
  • Start date Start date
M

Mavis

Hi All,

I hvae 3 fields Text51, Text52 and Text53.
In the fields:
Text51: P&I Credit
Text52: =Sum([InvoicedAmount]/[InvoiceROE])
Text53: =Sum([P&ICredit])

I will like to sum up the total of this 3 fields. Anyone can advice how can
i do so???
 
Hi,

I tried the below way but when the user try to open the report it prompt to
enter the vaule of "Text51", Text52" and Text53.



Software-Matters said:
Create a field in the footer and then add them together as follows:
newfield = Text51 + Text52 + Text53
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>


Mavis said:
Hi All,

I hvae 3 fields Text51, Text52 and Text53.
In the fields:
Text51: P&I Credit
Text52: =Sum([InvoicedAmount]/[InvoiceROE])
Text53: =Sum([P&ICredit])

I will like to sum up the total of this 3 fields. Anyone can advice how can
i do so???
Click to expand...
Click to expand...
 
Hi,

I change the code to =[Text51]+[Text52]+[Text53] and it works but when i
places this code in a group, the result only shown in the first group.

Please advice.
 
Hi,
If you have added the text fields to the group footer you need to add
another 3 that sum these in the report footer as follows:
TotalText51 = Sum([Text51])
TotalText52 = Sum([Text52])
TotalText53 = Sum([Text53])

Then you add these together i.e. GrandTotal = [TotalText51] + [TotalText52]
+ [TotalText53]
 
Back
Top