Access Marco Question?

Question

I have one query with 600 entries.

I need those 600 entries in a table I made.

How do I make a macro that will take the entries from the query and put them in the table?

Answer 1

First, change the select query that you made into an Append query.  When you change the query, it will ask which table you want to append to.  Select the table you want the records to go into, then in design mode, make sure all of your fields go to the proper field in the new table.

Now to create your macro.  Add a New Macro.  Under Action, select OpenQuery from the drop-down list.  Select the append query from the list under Query Name.  You can keep the View as Datasheet and Data Mode as Edit.  Save the Macro and run it.