newbie question - how to get macro to add field to table?

[IP]

I have a number of queries I want to run from a macro. No problem, however,
I also want to automatically add field to table before these queries are
run. How do I do this, the actions seem quite limited. I am having trouble
finding reference to this sort of automation? Can anyone help??

 

[Steve Schapel]

IP,

You can use a RunSQL macro action to run an "ALTER TABLE ADD COLUMN..."
statement. However, this is an unusual thing to do. Could you explain
a bit more detail about what this new field is and why? Maybe there is
a better way to do it.