Add Column to a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello-
How do I add a column to a table and enter in it the text "FY 2007" in every
row? I basically forgot to add that field when I created the table and now I
woul like to add it.

Thank you.

Filo
 
Create the field with the design table interface.

Make a backup.

Make a new query, open it in SQL view, type something like:

UPDATE yourTableNameHere SET yourNewFieldNameHere = "FY 2007"

and run the query.


That should do it.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top