Generating Random Number/ID
I am wondering if someone can lend me a hand. I am trying to create a random Id using letters, dates and random letters/numbers to look like this:
B = Random Letter
20051103 = Current Year, Month, Day
1T4SZ = Random Letters and Numbers
B200511031T4SZ is how it would look when it is entered into my table.
I am struggling on how to do this.
Can someone lend me a hand on how to create this?
Basically I will update this field up my update to my table from a form.
I am writing this back to an Access Database. I need help generating the Id and the concanation.
Thanks for any help that can be provided.