add a number

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

i have a table which has numbers in it for example

256
156
234
411

is there a way to add a number in front of each like
1256
1156
1234
1411
 
Create a new query in design mode - do not use the wizard.
Add the table your field resides in.
Drag and drop ONLY the field to be changed. Then from the
menu choose Query > Update query.
In the row that says Update To:

Format([field1],"\1000")

Then click the Go button[!] - red exclamation point.

Where field1 is the name of your field and \1 means add
this literal character 1 and the 0's are place holders -
print a zero if no number exists.
Look up Format() function in help for more info and under
User-defined formats.

jmonty
 
Back
Top