Auto updating time on all record

[Martial Bachoffner]

Hello,



I have 600 records where I have to set the time 9 minutes earlier of what it is actually.
Ex: a time who is 9:00 AM will be 8:51 AM.
Is there a way to have all the 600 records updated at once?
I know how to do it in Filemaker Pro but I'm new to Access.

Thanks,
Martial

[CJ_London]

use an update query

Update myTable
SET TimeField=dateadd("n",-9,TimeField)

[Martial Bachoffner]

Thanks, I will give it a try.

use an update query

Update myTable
SET TimeField=dateadd("n",-9,TimeField)