How to start renumbering from a certain date on monthly and yearly level in a append query. So for every year, for example 1st April to 31st March we get a new serial number and similarly on monthly ground from 1st date of every month.
Every Year on 1st April the Yearly number should reset to 1 and
similarly Every Month on 1st day of that month it should reset to 1
Every Year on 1st April the Yearly number should reset to 1 and
similarly Every Month on 1st day of that month it should reset to 1
Last edited: