Hi
I am trying to export a field value to a file, but I need the output in a spesific format. The result should contain 5 digits. The output can be both 3 and 4 digits and the filler is 0 in front.
e.g
Value 1. 123 = 00123
Value 2. 1234 = 01234
Can anyone help me?
eroness
I have a table that I need to update. The field is alphanumeric and goes like
Dc0001
Dc0002
Dc0003
Dc0004
I want to add an extra 0 onto them so would be
Dc00001
Dc00002
Dc00003
Dc00004
As there are a few thousand records like this I don't want to do it manually and just wandered how would I do this in an update query or I would I need some VB code.