Grand Totals on Forms

[Guest]

I have a form on which there are a series of records in a matrix – example as
follows

Amount Amount Amount

Record 1 50.00 80.00

Record 2 50.00

Record 3 50.00

Record 4 50.00 50.00


Totals 150.00 100.00 80.00

I had a problems with calculating the totals, but thanks to previous advice
received, these are now OK

However, I now want add a grand total of the totals on the form.

I created a text box and entered the following in the source.............

=Total1+Total2+Total3 (where Total1, Total2 and Total3 are the names of the
controls on the form).

I do not get an error, but the grand total appears blank on the form.

 

[Guest]

hi rillo,

i had a similiar problem, first i added all the columns then i added an
unbound field to the form with this code inside the field

=Sum([brokerfee])+Sum([procfee])+Sum([solsfeeamount])+Sum([lifefee])+Sum([gi
fee])

the names in brackets being your colum fields. this works for me, so should
for you. the only problem is if you have a null value in ine of your totals
it wont add. this can be over come using a nz function (not sure how to do
this but this forum will help you) of set a default value of '0'.

hope this helps

richard