[AccessD] Format Year in a number

Gustav Brock gustav at cactus.dk
Mon Aug 16 10:02:46 CDT 2004


Hi Virginia

You can pull all this into the Format() function:

EvalNo:
  Format([DisciplineNo],"\E\V\A\L\-000") & _
  Format(Date,"\-yy") & _
  Format([EVTaskNum],"\-000")

or

  Format([DisciplineNo],"\E\V\A\L\-0") & _
  Format(Date,"\-yy") & _
  Format([EVTaskNum],"\-000")

/gustav


> 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")




More information about the AccessD mailing list