auto fill

[Sanj]

I have inserted a column in the table and named as "MONTH"
field. I would like to fill this field with "AUG 03" as a
month name. Can anybody help me how to fill this column
with this same record name.Thanks

Sanj

 

[Joan Wild]

First you should take the opporunity right now to change the name of your
field as 'Month' is a reserved word.

You can accomplish this using an update query.

UPDATE MyTable SET MyTable.mymonthfield = "AUG 03";