Retaining Leading Zeros

[RICKA]

I have a query and i want to join 2 fields together

eg. JOB:[Type_id] & [Number_id]

this works fine but i need to put an input mask on the field

type id is 2 letters
number id is 4 numbers (0001)

however whan the filed JOB is created all leading 0's from Number id are lost

how can i prevent this

RICKA

 

[DaveJHPT]

JOB:[Type_id] & format([Number_id],"0000")

Dave

 

[RICKA]

thanks works a treat