Hello all,
Can someone kindly help me with a code to automatically archive data by month-end and year-end.

Define what you mean by 'archive'. Delete records? Move records to a different table? Do something else?

commented: move records to a different table +0

Okay, so move to a different table. Do you have a query that does that already? What part exactly do you need help with?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.