I have a query with a set of records having a date field that I need to increment by 12 months leaving the day the same. All records in the query need to have the date advanced 12 months so some sort of Do While not end-of-file would seem reasonable. This needs to be done on a regular basis so I'll be placing a button in a form that runs a macro (preferred) or VBA or combo of both. Is there a way to do this using macros only? I prefer macros but I'll do whatever it takes to get this job done.