Create sequential ID value based on the year that a record is added
With Access versions 2010 and later you can use an event-driven data macro to generate the sequential ID. For example, say you have a table named [poledata]. Open it in Design View and add two fields: alternate_id_seq – Numeric (Long Integer) alternate_id – Text(20) Save the changes to your table and then switch to Datasheet … Read more