Hello,
This is my first post..so forgive any mistakes.
I have a continuous form which totals four fields in a single record (in an unbound text box)but when I tried to grand total for whole form in the form footer it shows #error. I have tried couple of methods but none of them works.
I really need help on this.
I tried like this:
=Sum(Nz([Price-A1],0)+Nz([Price-A2],0)+Nz([Price-A3],0)+Nz([Price-A4],0))
Price-A1 to A4 are the 4 fields. I have also included images.
This is my first post..so forgive any mistakes.
I have a continuous form which totals four fields in a single record (in an unbound text box)but when I tried to grand total for whole form in the form footer it shows #error. I have tried couple of methods but none of them works.
I really need help on this.
I tried like this:
=Sum(Nz([Price-A1],0)+Nz([Price-A2],0)+Nz([Price-A3],0)+Nz([Price-A4],0))
Price-A1 to A4 are the 4 fields. I have also included images.