> I require a function where Access will generate an Autonumber with
> each number beginning with the letters 'BNS'; I would like about 8
> numbers after this. Also the numbers have to be unique. I am still a
> novice in Access so if someone can give me a step by step guide it
> would be great!
No what you want is a random number (autonumber will generate one) andReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
then you want to DISPLAY that number with the letters "BNS" in front of it.
Don't bother trying to store the "BNS" in a table as there is no need to.
There are several ways of displaying the BNS depending on where you will
Note: the user should never see the table directly or enter or edit dataReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
there. They should only see data in forms, reports and maybe queries.
Tables are only buckets of data and a list of field definitions.