Calculation in textboxes (2000)

Topic

New Reply

Hi Guys,
i have a frmDebitNote based on tblDebitNote, and I want to calculate the sum of the 3 fields named..
Amount
txtAmount2
txtAmount3
So what will happen after the numbers have been inputed, it will sum it up and store it in the field “total”.
Thankyou in advance

Reply | Quote

Replies

In general you should not store Total in the table, since it is derived information. You can calculate the sum in a query, by creating a calculated column:

Total: [Amount]+[Amount2]+[Amount3]

You can also calculate it on the form, by setting the Control Source of theTotal text box to

=[Amount]+[Amount2]+[Amount3]

If you do need to store the total in the table, see post 330877. The method described there can be adapted to your needs.

Reply | Quote

In general you should not store Total in the table, since it is derived information. You can calculate the sum in a query, by creating a calculated column:

Total: [Amount]+[Amount2]+[Amount3]

You can also calculate it on the form, by setting the Control Source of theTotal text box to

=[Amount]+[Amount2]+[Amount3]

If you do need to store the total in the table, see post 330877. The method described there can be adapted to your needs.

Reply | Quote

ok, thanks Hans. Got it working now, much appreciated

Reply | Quote

ok, thanks Hans. Got it working now, much appreciated

Reply | Quote