Search results

*I know that this may not be the best way of resolving the problem but this is not the actual problem but my way to simplify of explaining the "problem". I have a Table with 3 fields. Field 1 - Auto Number Field 2 - First Name Field 3 - Last Name Initially, the Table was sorted via First Name...

Hi all, First post and hope that someone can help. I need to create an auto generated key with this format. [Auto Number]+[(Current)MM-YYYY] [Auto Number] = 0000 [(Current)MM-YYYY] = Current Month + Year Pls help.:(