how to copy text string to all records in column in Access 2002

T

tonys

I added a column to a table and want to copy a text string to the remaining
cells in the column in Access 2002. Also, I want to export the amount column
as text with zero filled and without the decimal point. Can some tell me how
to do this in Ascess 2002.

TS
 
T

tonys

The update & set stmt worked great, thanks. The format stmt also worked however
when I run export to a fixed width text file, the amount field loses the
leading zeroes and is left justified. How can I retain the leading zeroes in
the text file?
Tonys
 
Top