Search results

I want to create an (8) digit number such as 20121234 (1st four are the year and the last four digits would be an auto number) how would I go about doing this. I am a new user to Access and I have built my (4) main tables and before I go create my forms sheets ect I want to get my "id" column...