Add new Table Field

[BRANDON99]

Hi

I would like to add a text field to a table. I am sure this can be done with a query or code but after searching can not find an answer. Can anyone suggest a solution?
I am using Access 2003

Thanks

Stephen

 

[PHV]

Use the ALTER TABLE instruction.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

This begs the question of why not simply open the form in Design View?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!