Copying Query Results into a Table

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
 
M

Marshall Barton

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