Q1 ok thank you i didnt know that. so when i put information in it has to be put in on the table?
Q2 yes thats right but no i have no idea how to do this.
Q3 ok i will look into it again
thank you
thank you paul for the quick reply
the number will be stored on the form for future reference.
the number wont hiy 999 as when the new month starts the second set of numbers change then the third set of numbers should return back to 001 and start all over.
i did look at the link provided but...
in a form i need to get a unique number,
the first two need to be the curreny year, the second two the current month then the third three need to automaticly go from 001 to 002 to 003 etc.
so i end up with 1301001.
any help please:confused:
Hi all
i had never used access before but now i have to set up a program for a new business so i have got to learn lots fast. i hope you all can help with the many questions i will be posting
thank you all in advance:)