Big Mistake

[R CRAWFORD]

i have a db with 1.5 million business names etc. unfortunately i have manageged to delete all the zero's off the beginning of the telephone field and fax number field, somebody must know of a way to help put them back in.

Many thanks in anticipation. Bob

[andygaunt]

Bob,

You can run a replace command on each field,

Find just one record to test to make sure you are happy with the result.

click in the field and choose records replace.

Specify a calculated result and type in;

"0" & number field where number field is the field name

Repeat for each field.

Once happy, show all records and run the replace.

Be aware that no one else should be using the database when you do this to avoid record locking.

HTH