<div>
Unfortunately no, you can only operate on one field in a single ALTER TABLE statement so you will have to process each new field as individual statements.<br />
<br />
Steve
</div>


Unfortunately no, you can only operate on one field in a single ALTER TABLE statement so you will have to process each new field as individual statements.

Steve

<div>
steve: email me at profile addresss (please, thankyou..)
</div>


steve: email me at profile addresss (please, thankyou..)

<div>
on it's way from spmazzola {at} hotmail {dot} com
</div>


on it's way from spmazzola {at} hotmail {dot} com

<div>
Lakshmana,<br />
<br />
Did this answer your question?<br />
<br />
perkc
</div>


Lakshmana,

Did this answer your question?

perkc

<div>
The answer is no, you cannot add more than 1 field at a time with a single ALTER statement so the question has been answered.<br />
<br />
Steve
</div>


The answer is no, you cannot add more than 1 field at a time with a single ALTER statement so the question has been answered.

Steve

<div>
<div class="content wysiwyg-content">
Hi <br />
Can we Insert Multiple Fields in to a table with a single Alter Statement. ?<br />
<br />
I fyes please give me the Syntax<br />
<br />
Thank You<br />
<br />
Lakshmana
</div>
</div>


Hi 
Can we Insert Multiple Fields in to a table with a single Alter Statement. ?

I fyes please give me the Syntax

Thank You

Lakshmana

How Can I insert Multiple fields in a table with a single alter statement

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.