preceding zero's

[Ouch]

help

i have a id code that is generated from three difrent feilds

the first field is long interger and reads 0039
the second field is a year and reads 2003
the third field is a autonumber 268

when i join the fields in the query to get my id number it looses the preceding zeros.

these are very important

it gives this
39_2003_268

and i need this
0039_2003_268

any idea's

 

[Steve101]

Assuming the fields are called Fld1, Fld2, and Fld3, then use the following expression:

ConcatFld = format(Fld1, "0000&quot & _
format(Fld2, "_0000&quot & _
format(Fld3, "_000&quot

These will retain any leading zeros, as well as embed the underscore characters as required.
Hope this helps,
Steve

 

[LittleSmudge]

Not only a multi post - Thwack.

but also - how does this relate to Tables & Relationships ?


thread701-306013