Base: How to make Integer field(s) that goes to zero each year


I’m trying to make a small database for My condo so that I can Make and print receipts of quotas and keep the register.

I need to make an integer field with number of receipt (easy enough), but I need to make a mechanism of starting each year a new series of receipt making the number go to zero or one.

Can anyone give me a hint?


The information provided is not sufficient to advise on. If simply an integer field just enter 0 or 1. But you possibly failed to mention it may be an auto increment field and a Key field. More information please.

In dealing with Base it is typically helpful to know your OS, LO version being used & which DB you are using.