Ok here is what I got, it works, but it has a delay when I press the Update record, that is: I have to press twice the update to make changes. Or should I say, I have to repeat the update process again in order for it to take effect into the database.
Do you know why this happens?
The other thing is, where can I place this same code into the insert record since the insert page does not have a server behavior.
==================================================================
SELECT OE_ID, Date_, Trip_No, Fuel, Oil_Change, Tire_Repairs, Parts, Insurance, License, Toll,
SUM(Fuel+Oil_Change+Tire_Repairs+Parts+Insurance+License+Toll) AS Total
FROM operating_expenses
WHERE OE_ID = colname
==================================================================
many thanks,
