How to autogenerate a project number?

[Trinity99]

Hi all,

I have to create a form for a little database in Access.

One of the fields should be a autogenerated projectnumber like:

PJ-YY-MM-DD-XX where

PJ = static
YY= year
MM= month
DD= day

XX= incremental Number starting every day at 01 !!!!!

can anyone help me?

Thanks in advance



Ivo

[Yance]

Here i enclosed the project according to your question. Hope this can solved your question. Please send me your feedback after you've tested it.