Prefix to a number

[richvalve]

Hello

I've designed a database for the job numbers at my company. However instead of just the normal 'autocount' ie 1, 2, 3 for the jobs. I would idealy like a prefix of 02/001, 02/ 002... etc. As 02 = year 2002.

I would of thought this was pretty simple, but it does not appear so!

If anyone has any advice, it would be greatfuly recieved!

Many Thanks

 

[tomschafer]

There are 2 options...
Change the format of the field in the table to..."/02/"#
or
Change the RowSource of the field in the report to..."/02/" & FieldName

Note- FieldName in the second option is the name of the field in the table/query.