Adding Fields

.Justin

Registered User.
Local time
Today, 04:24
Joined
Jun 29, 2009
Messages
38
So I have a database where I enter Cost of Product and the the Postage Cost. I then want it to calculate the total cost. These three things are fields in my table:

Cost
Postage Cost
Total Cost

How do I get the Cost & Postage Cost fields to add up to put the total into the total cost cell?

As simple as possible?

Thanks
 

Attachments

  • Untitled.png
    Untitled.png
    27.8 KB · Views: 87
You can do the following
Into the event procedure of after update for the cost you write
Me.totalCost = Me.Cost + Me.PostageCost
And on the postage cost control also on the after update event write the same code so in both controls anything you modify in the numbers it will always update your total cost
I hope that solves the issue
 

Users who are viewing this thread

Back
Top Bottom