Thread: [Solved] Auto insert year only
View Single Post
 
Old 12-16-2016, 09:49 AM
mrsevilbrooks mrsevilbrooks is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2016
Posts: 2
mrsevilbrooks is on a distinguished road
Default Still confused

I'm a real newby to this version of Access (2016). I want to make an automatically incremental file number for each of my records. I want this format: YY-000-A. How do I get that both in a table and in my reports? Right now I have it split into 3 different fields. Is there a way to put it all in the same field? If not, how to I make the table field/report field just give me the two number year automatically? Thanks.
Reply With Quote