G
Guest
Hi
I am creating a database of which certain forms contain customer contractual
values. I would like to calculate these values to give a sub total for each
customer record. I have created a text box for the total value and entered
the expression =(sum([field name 1]))+(sum([field name 2)) but this gives me
the overall total for the values entered in those fields and what I am
looking for is just the sub totals for the specific customer. i have tried to
include the Customer ID (which is unique)within the expression but it keep
spitting out an error message.
i would appreciate your help.
Many thanks
Úna
I am creating a database of which certain forms contain customer contractual
values. I would like to calculate these values to give a sub total for each
customer record. I have created a text box for the total value and entered
the expression =(sum([field name 1]))+(sum([field name 2)) but this gives me
the overall total for the values entered in those fields and what I am
looking for is just the sub totals for the specific customer. i have tried to
include the Customer ID (which is unique)within the expression but it keep
spitting out an error message.
i would appreciate your help.
Many thanks
Úna