Hi All,
Could I have some help with this please.
I have a continuous form which has some number fields in the detail section.
I have set up the fields vertically in the detail section.
In the form footer to add up the columns I have used this eg:
=sum([Fieldname])in a text box.
This works ok to add up the first field. What I want to be able to do is to add up all the fields together.
I have tried this =nz([textbox1])+nz([textbox2]) but this will only show the result for individual text boxes.
What is the correct formula to get this to work.
Many thanks,
Ken
Could I have some help with this please.
I have a continuous form which has some number fields in the detail section.
I have set up the fields vertically in the detail section.
In the form footer to add up the columns I have used this eg:
=sum([Fieldname])in a text box.
This works ok to add up the first field. What I want to be able to do is to add up all the fields together.
I have tried this =nz([textbox1])+nz([textbox2]) but this will only show the result for individual text boxes.
What is the correct formula to get this to work.
Many thanks,
Ken
