Change table

[Guest]

Hi,

I have a table named "Table1"

I want to filter out some of the entries so I linked it to another table.
At first Table1 has 10,000 entries and after the query it has only 150
entries.

The problem is that when I use the make table query --> I have to create
another table "Table2". But I have all these queries that use "Table1".
Is there some way to update "Table1" without creating a whole nother table?

Thanks for your help.

 

[Guest]

You shouldn't need to create another table just to filter records. Just
create a query and use that to filter the records.