Leading Zeros

[dirtbiker1824]

I have a table with a Job Order field and a Key Op field. I then have an Update query to combine these two fields and update the JOKO field in the orrigional sheet. My problem is that I need the leading zero on the Job Order to stay. I accomplish this in the orrigional sheet by changing the type to number, Field size to double and format to 00000 since my job order is a 5 digit number. When ever I run the query using the function [JobOrder]&[KeyOp] the leading zero does not show.



Example:

Job Order|KeyOp|JOKO
04401|A02|4401A02
23101|F01|23101F01

[pbaldy]

Try

Format([JobOrder], "00000") & [KeyOp]