Need to display leading zeros in concatenation

[Marty]

In my table I have a job code field that is formated 0000. I need to
concatenate that filed with the job title field in a query with a dash
between. Example:
Job Code: 0006
Job Title: Slave
Result: 0006-Slave

I've done the concatenation in an expression field in my query but it drops
the leading zeros. Here's what I've used:

Expr2: [Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Code] & "-" &
[Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Title]

I don't have the option of changing the job code field to text because the
data comes from a query run to Excel from in another program and when I
change the format of the column to text I lose the zeros.

Thanks for your help.

 

[Wayne-I-M]

Format([Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Code], "0000") & "-" &
[Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Title]

 

[Marty]

Thanks so much! Works like a charm!

Format([Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Code], "0000") & "-" &
[Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Title]


--
Wayne
Manchester, England.

In my table I have a job code field that is formated 0000. I need to
concatenate that filed with the job title field in a query with a dash
between. Example:
Job Code: 0006
Job Title: Slave
Result: 0006-Slave

I've done the concatenation in an expression field in my query but it drops
the leading zeros. Here's what I've used:

Expr2: [Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Code] & "-" &
[Tbl_NCBHNewHire60-DayTBComplianceStatus]![Job Title]

I don't have the option of changing the job code field to text because the
data comes from a query run to Excel from in another program and when I
change the format of the column to text I lose the zeros.

Thanks for your help.