Fill Columns and Lowercase

[tomhorn80]

Hi all, couple of quick questions that the newbie cant figure out.

1. How can I make a new column in an existing table and then fill it with the same value, at the moment I have to copy and paste every record?

2. How can I convert the contents of a column to lowercase other than doing a find and replace for every letter of the alphabet?

Any help will save me hours of time and help prevent my chronic copy and paste cramp.

Thomas

 

[Smart]

1. How can I make a new column in an existing table and then fill it with the same value, at the moment I have to copy and paste every record?
When creating the column give it a default value.
any new record written to the table will give the column its default value

2. How can I convert the contents of a column to lowercase other than doing a find and replace for every letter of the alphabet?

in the format section of of the column type <

 

[tomhorn80]

I knew about the default value but I already have a table with a couple of hundred records, I need to insert a new column and then fill it with the same value, setting the default value only does it for the new records added.

I take it you mean the format section in the design view for lowwercase, what value would set it to lowercase?

Thomas