Trying to change a sample table year of the date. Ex: If date is 3/4/2010, change it to 3/4/2016. I can do it manually, but there are over 10k of records. Please help...
Novice
Windows 10 
Access 2007
Trying to change a sample table year of the date. Ex: If date is 3/4/2010, change it to 3/4/2016. I can do it manually, but there are over 10k of records. Please help...
Excess Access
Windows 10 Access 2016
Google "Access Update Query".
If you have any questions, come back here for answers.
Who is John Galt?
Windows XP Access 2007
You'll also want the DateSerial, Month and Day functions.
Change The Year End Date
Posting Permissions
Reply With Quote