You could use a Parameter Query and input the dates you want, or you could use an Update Query to update the year(s) in your table.

Do you have a form to show the dates you want? What are the dates you’re storing in the table?

If you want it to happen automagically without you having to run any query manually, you'll need to be able to use macros or VBA. Are you comfortable doing or trying to do that? If so you would need to give us an idea of your table fields and if you have a main menu or other form that opens regularly that could automate it.

For example, if you have a table such as "SettingT" that has fields in one record like "CycleStartDate" and "CycleEndDate" or however your structure is and then at the minimum, the name of a form that could be set to check the end date and, if it's passed, then update the dates.

But we need more info to be able to help you specifically.

Please be more specific. See Rule #2.

As they guys have mentioned, we'll need a bit more detail about your table setup and whether you're comfortable using VBA or macros. If you can provide the structure of your table and give us more details, we'll do our best to get you going.

The simplest way, IMO, to accomplish this is to process it in the On Open or On Load event of a form, such as a main menu. Something that you open regularly so that it processes frequently enough to do the update. I might also use a TempVar to indicate whether it has already been done recently while the database is open if you have a lot of activity in your database to help reduce busy time. Listed below are some videos that discuss these topics:

Form Opening Events
Date Math
TempVars

If you want help putting the code together after watching these videos, let us know. And again, be specific. In your first post, you mentioned a Start Date and End Date and you table image shows PermitExpires and Terminated, so we'd need to know exactly which field to trigger the change on, etc.

Miguel, the key thing to understand is that Access is not going to just wake up one day and magically change those dates for you. If you want something to happen automatically, something has to trigger it. That trigger can be an event, some code, a button you click, or a query that runs on a schedule. You just have to decide when you want that check to occur.

For example, like Donald said, you could put VBA code in the On Open or On Load event of a form that opens regularly, like your main menu. When the form opens, it can check the current end date, and if today's date is past it, update both the start and end dates to the next three-year cycle. That way it happens automatically as part of normal use.

Another option is a button on a form that runs an update query. That's not fully automatic, but it gives you control. Or you could run a maintenance routine when the database first opens each month that checks and adjusts the dates if needed.

So the real question is not "can Access do this?" It absolutely can. The question is "when do you want it to check and update?" Once you decide on that trigger, the rest is just straightforward date math.

Richard, thanks for the easy-to-understand explanation; Donald on the other hand is more technical, yet helpful. I will try his top two suggestions.
I will also try a button with an update query.
Thanks