Solved Add Prix to field

[Number11]

So i need to add this to any numbers that are only 5 string long

CorrectNumber:"2000" & [InvoiceNo]

but i only want to correct if the current number is less than 6 ?

how would i go about this please

 

[Ranman256]

in a select query , 2 fields: bring down [invoiceNo] and make another fld: Len([invoiceNo])
in its criteria, set it to: <6
view the results,

now convert it to an UPDATE query,
change [invoiceNo] to: "2000" & [InvoiceNo]

 

[Gasman]

CorrectNumber:IIF(Len(InvoiceNo) < 6, "2000" & InvoiceNo,InvoiceNo)