Job Number

[IanWebb1982]

Good afternoon all

I am creating my first Access database in over 20 years and I need a 'Job Number' field which is auto generated and the record is saved. This would be a combination of the Primary Key, which is an auto number, and a 3 character text field which is already in database.

I cannot find a way to do this, is it even possible?

Thanks in advance

[mike60smart]

Hi Ian

Yes it can be done but why do you need it?

[IanWebb1982]

Hi Mike

Thanks for replying so quickly.

Currently we run a 'Job Log' on an Excel spreadsheet but there has become a greater need for reporting on this which I know Access will be better for. We give each job a unique number using three letters from their name, for example ABC Electrical being the first job in the database would create a job number 'ABC1', the next job for DEF Electrical would be 'DEF2'. This makes it easier for us to identify the job internally

Thanks

[mike60smart]

Hi Ian

Rather than storing the Job Number you can display it on your Data Input Form and also on any Report that you generate by using the following in an Unbound Textbox

=[NameofPrimaryKey]&""&[NameField]

[IanWebb1982]

Brilliant - thanks Mike

I think I'm almost there, but how would I pull the Customer Reference from another table in the unbound textbox?

Thanks

[mike60smart]

Hi Ian

You would normally do this in the design View of your Form(s).

Do you have a Main Form and a SubForm for your Data Input?

[ssanfu]

Before you use an autonumber as part of a 'Job Number' field, see these:

AutoNumber
----------------
Purpose: Use an AutoNumber field to provide a unique value that serves no other purpose than to make each record unique. The most common use for an AutoNumber field is as a primary key.



Autonumbers--What they are NOT and What They Are