"dmax" new year

  • Thread starter Thread starter adam
  • Start date Start date
A

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.
 
adam said:
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.
Click to expand...


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
 
Back
Top