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.