[AccessD] Format Year in a number

Yes, the current year, but I need the year formatted with just 2 digits. I
tried this & get 2004, I just need 04.
**********************
You mean the current year? 
 
EvalNo: "EVAL-" & [DisciplineNo] & "-" & Year(Now)) & "-" &
Format([EVTaskNum],"000")
 
Susan H. 
 
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> 
http://databaseadvisors.com/mailman/listinfo/accessd
<http://databaseadvisors.com/mailman/listinfo/accessd> 
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com>