CODEWITHSUNDEEP
ms-accessvba
mack
mack

Reputation: 2965

MS Access Update All Dates in a Table

I have a table in Access where I am trying to update all the dates to one month prior than what the table shows. If the table shows 2012/11 it should be updated to 2012/10 etc. I'm assuming the best way to do this would be in VBA? Any suggestions?

Upvotes: 2

Views: 210

Answers (1)

stuartd
stuartd

Reputation: 73243

Update TABLE Set [dateColumn] = DateAdd("m", -1, [dateColumn])

Upvotes: 3

Related Questions