Copying Query Results into a Table

  • Thread starter Thread starter Ange Kappas
  • Start date Start date
A

Ange Kappas

Hi,
I have a Query which filters out certain records from an existing
Table, how can I copy these filtered out records which were based on certain
criteria, to an existing Table which have exactly the same name of fields as
the Query?

Thanks
 
Ange said:
I have a Query which filters out certain records from an existing
Table, how can I copy these filtered out records which were based on certain
criteria, to an existing Table which have exactly the same name of fields as
the Query?
Click to expand...


Try changing the query to an Append query (using the Query
menu). Then change the criteria to the opposite.

I could help with that if you post a Copy/Paste of your
query's SQL view.
 
Back
Top