<div>
In DDL you can only execute one statement per querydef; what you typed isn't allowable.
</div>


<div>
Is there a method for me to drop two columns in one Statement in SQL for Access?
</div>


<div>
<br />
<br />
you can do it in VBA<br />
<br />
CurrentDb.Execute &quot;alter table &nbsp;A_Trim drop column Name_First, Name_Last&quot;<br />

</div>


<div>
Can I do this from the Macro tab under Objects, or does it have to be through a Module. I am gaining speed on how to work with Macros and Modules, so more detail is appreciated.<br />
<br />
Thanks
</div>


<div>
how to do in sql<br />
<br />
Alter table A_Trim drop Name_First, Name_Last<br />

</div>


<div>
right ok, question wasnt accepted when I posted, good luck with your vba method.<br />

</div>


<div>
Sorry RR, I accepted before I saw your response. I will re-post the question so you can earn deserved points as well 
</div>


<div>
Hi, not to worry, there is no need. I just saw this after I saw your other post and did wonder why. I appreciate the fact that you recognised my efforts though<br />

</div>


<div>
<div class="content wysiwyg-content">
Please advise on how to DROP two columns from an Acces 2003 Table in one Statement.<br />
<br />
The following was unsuccessful:<br />
<br />
Alter table A_Trim drop column (Name_First, Name_Last)<br />
<br />
Thanks
</div>
</div>


Please advise on how to DROP two columns from an Acces 2003 Table in one Statement.

The following was unsuccessful:

Alter table A_Trim drop column (Name_First, Name_Last)

Thanks

In DDL you can only execute one statement per querydef; what you typed isn&amp;#39;t allowable.

Is there a method for me to drop two columns in one Statement in SQL for Access?



you can do it in VBA

CurrentDb.Execute &amp;quot;alter table  A_Trim drop column Name_First, Name_Last&amp;quot;


Can I do this from the Macro tab under Objects, or does it have to be through a Module. I am gaining speed on how to work with Macros and Modules, so more detail is appreciated.

Thanks

how to do in sql

Alter table A_Trim drop Name_First, Name_Last


right ok, question wasnt accepted when I posted, good luck with your vba method.


Sorry RR, I accepted before I saw your response. I will re-post the question so you can earn deserved points as well 

Hi, not to worry, there is no need. I just saw this after I saw your other post and did wonder why. I appreciate the fact that you recognised my efforts though


Access - SQL Drop Columns

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.