O
Oli_Oli_Umphry
Guest
I have a form that runs a simple macro. The problem is I'm getting the "Invalid Use Of Null" error becuase some of the fields are empty. There are 12 fields....one for each month. I know there's a way to use the nz function but I do not know how and where to apply it for each field.
example:
quantity month total price
10 jan: $3548.00
feb:
10 mar: $3548.00
The Macro calculates the totals for the year.
Thanks in advance
example:
quantity month total price
10 jan: $3548.00
feb:
10 mar: $3548.00
The Macro calculates the totals for the year.
Thanks in advance