Susan Harkins
ssharkins at bellsouth.net
Mon Aug 16 09:51:56 CDT 2004
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 Website: http://www.databaseadvisors.com