G
Guest
Hi
I have a simple database that provides quotations for work to be undertaken.
There is only one table containing all the fields. On the nain form I have
four fields: Price, Price2,Price3 and Price4 to allow for up to four
different pieces of work on one quote. I want to be able to total the costs
of each of the four elements and display as a total figure on the form.
I have used Total=Sum([Price]+[Price2]+[Price3]+[Price4]). This works,
however, it totals the cost of ALL the figures in all the records and I just
want the total for each individual record to display on the form of that
record.
many thanks for any suggestions.
I have a simple database that provides quotations for work to be undertaken.
There is only one table containing all the fields. On the nain form I have
four fields: Price, Price2,Price3 and Price4 to allow for up to four
different pieces of work on one quote. I want to be able to total the costs
of each of the four elements and display as a total figure on the form.
I have used Total=Sum([Price]+[Price2]+[Price3]+[Price4]). This works,
however, it totals the cost of ALL the figures in all the records and I just
want the total for each individual record to display on the form of that
record.
many thanks for any suggestions.