Jobstring

[JNITS]

I have 3 columns:
Jobtype (examples would be FA, FR, SP)


State (example AL, CA, FL)
Job# (1001, 1002 etc)

The 4th column is:
Jobstring

I want Jobstring to be the combination of data entered in Jobtype, State, Job#
so the Jobstring would look like this (in the perfect Access world)
FACA-1001

I can't figure out how to do this.

[June7]

This can be calculated in table Calculated type field or query or textbox. Saving to a normal field in table would require code (macro or VBA).

Use concatenation.

[Jobtype] & [State] & "-" [Job#]

Advise not to use space nor punctuation/special characters (underscore only exception) in naming convention. Better would be JobNum or Job_Num.

[CJ_London]

missed an ampersand

[Jobtype] & [State] & "-" & [Job#]

[JNITS]

It worked. Thank you very much

[June7]

Oh, rats! Thanks for the catch, Ajax.