var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Saving Query result to Table
Have working code at:
which creates and opens a query. The original query was an append query and I need the same from this query or way to save into table "tblMODfnr".
All HOWTOs and helps I've read, do not show a way to do this and when I click "File" + "SaveAs" with the query open, table is not an option.
How do I get this done?
Do I need to change my SQL to "INSERT INTO" and then "DoCMD****nSQL"?
Any help appreciated!
INSERT INTO is used to insert data in to existing tables. If you want to save a query as a brand new table, have a go with SELECT INTO.
Thanks, mind was blank this morning, so having an "Uh-duh" moment.
Should say "I knew that"!