Adding and Dropping Columns in a query

[sdkramer]

Any way I can add a column or drop a column in a query?

 

[dcx693]

I assume you don't mean in design view where you view the query grid? How is your query structured? Are you creating a dynamic query? Or are you talking about a stored query in the database window?

 

[sdkramer]

structured at the moment. Here's the problem I can create a column with alter table tablename add column bob text notnull; for instance but I don't know how to add more than one.

TIA,

Seth

 

[dcx693]

You can only work with one field per ALTER TABLE statement.