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

  • Thread starter Thread starter IP
  • Start date Start date
I

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??
 
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.
 
Back
Top