I want to increase the seconds display of a DateTime field by 30 seconds. I dont get any further. My update query is not working:
"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + (second(DateAct)+1) where IDMit = 2;"
Where is the mistake? Thanks for help
"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + (second(DateAct)+1) where IDMit = 2;"
Where is the mistake? Thanks for help