Search results

Thanks man, but if I understand correctly I have to make a form and refference that in the "project id" area? All I really want is the year 4digit and then a 4 digit number (not the date) but a number starting at 0001 and going up, this is going to be used for various fields in my company and I...

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...