Using the current year plus record number as a field in a form

[mduplantis]

Hello,



I have a fairly simple database with just a few tables. My main table uses an auto number as my primary key. We track work injuries each year and I think it would be nice to create a field that uses the current year plus a number that starts over at the beginning of each year to easily track how many records we have each year. The user could quickly glance at the field and see we have X number of claims for the year.

Example

2015-001
2015-002

The year would be easy enough using the Year(Now()) concatenated with a number and then plus 1. I am not sure how to make it start over each year and where I would put these formulas.

Thank you for any assistance.

Brent

[June7]

This is generating a custom unique identifier. Common topic. Review: https://www.accessforums.net/forms/a...ing-23329.html

[mduplantis]

Thank you. I did not search "custom unique identifier"