One than one statement in an SQL Query

[Guest_imported]

I need to add a field (ALTER statement)to a table then update(UPDATE statement) that new field.
Right now I have to use two seperate SQL queries to accomplish this. Is there a way I can write both statements
is the same query using SQL?

Thanks,
scotta

 

[tlbroadbent]

No, you can't do it. You can create a macro or module that will run the queries in succession if you need to automate the process in some way. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.