Guest_imported
New member
- Jan 1, 1970
- 0
In my database, there are three fields, one is the day, one called produced, and one called sold. Both produced, and sold are numeric values.
What I want is, when a user enters a new value for produced and sold, the database will check to see if there is already a value for them on the specific day, and if there is, it will take the sum of the entered value and the current value, and store that in place of the old value.
What command will allow me to do this?
What I want is, when a user enters a new value for produced and sold, the database will check to see if there is already a value for them on the specific day, and if there is, it will take the sum of the entered value and the current value, and store that in place of the old value.
What command will allow me to do this?
