Append leading zeros to a field during an appemd query

[craig1988]

Hi All



I have an append query that adds records to a master table. The inputter enters a start number (StartSerial) and an end number (EndSerial). These numbers will be used to generate a serial number of 6 characters.

I need the append query to append leading zeros to create the 6 character serial number.

So

If (len(StartSerial)=1) Then StartSerial = "00000" + StartSerial
Else If (len(StartSerial)=2) Then StartSerial = "0000" + StartSerial and so on...

Thats the logic above.

I need this adapted so the query can do this.

[June7]

If you always want six characters with placeholder zeros, try:

Format([input number],"000000")

[craig1988]

So Simple

Thanks June7