dominicdunmow
Technical User
Hi there,
I have a table that I'd like to archive, in order to do so I'm renaming it and adding appending the month in which it applies to. The code below adds the current month, but I'd like to add 2 months previous, e.g Format(Date, "MMM" - 2)
but I can't work out the code.
DoCmd.Rename "tblArchiveOSP_" & Format(Date, "MMM"), acTable, "tblOSPPrevious"
Can anyone point me in the right direction please.
Thanks
I have a table that I'd like to archive, in order to do so I'm renaming it and adding appending the month in which it applies to. The code below adds the current month, but I'd like to add 2 months previous, e.g Format(Date, "MMM" - 2)
but I can't work out the code.
DoCmd.Rename "tblArchiveOSP_" & Format(Date, "MMM"), acTable, "tblOSPPrevious"
Can anyone point me in the right direction please.
Thanks