"dmax" new year

[adam]

I have a calculated field behaving like an autonumber,
where the field value is increasing by one in every new
record, by using "Dmax" function.

Problem is when the year changes this number should start
from zero again, but the old values should not change
also. The situation looks complex for me, so any ideas or
advice would be highly apreciated.

Regards.

 

[Marshall Barton]

I have a calculated field behaving like an autonumber,
where the field value is increasing by one in every new
record, by using "Dmax" function.

Problem is when the year changes this number should start
from zero again, but the old values should not change
also. The situation looks complex for me, so any ideas or
advice would be highly apreciated.

It would've helped to see the code you're using, but I think
you can change it to something like:

newnum = NZ(DMax( . . . ), 0) + 1