Copying Query Results into a Table

[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

 

[Marshall Barton]

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?

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.