ms access update query

[bittu76]

can i change a blank space in table with zero by making an update query

for example in my table the field length is of 16 charecter, but due to the fault of data entry operator, only 13 charector was typed, rest three space which was to be filled with zero was not typed. the total no of data is large (35000) so it is not posibble to fill it manualy.

i want to design an update query which will replace all the blank space (three, ie 14-16) with zero (0).

'5467876654865 ' with '5467876654865000'

 

[Tim1]

Hiya,

You can do this quite easily. Is the column a text field or a number?

If is is a text field, you can do

UPDATE table_name
SET field_name = (field_name + "000&quot

If it is an interger, you can do

UPDATE table_name
SET field_name = (field_name * 1000)

Tim