[AccessD] Format Year in a number

EvalNo:
"EVAL"&"-"&[DisciplineNo]&Format("yy",[YourDateField])&"-"&Format([EVTas
kNum],"000")

Ed Tesiny
EdTesiny at oasas.state.ny.us

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
Sent: Monday, August 16, 2004 10:31 AM
To: 'accessD at databaseadvisors.com'
Subject: [AccessD] Format Year in a number

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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com