[AccessD] Format Year in a number

Hollis,Virginia HollisVJ at pgdp.usec.com
Mon Aug 16 09:30:44 CDT 2004


I need to assign a number for a document that contains the discipline
number, the year, and a new task number. I can't seem to get the year part
to work - how do I have it add the year to a number (and it must change
every year too)? The year would come after the discipline so the number
would be: EVAL-123-04-001.

 

EvalNo: "EVAL " & [DisciplineNo] & "-" & Format([EVTaskNum],"000")

 

Virginia




More information about the AccessD mailing list