Access 2002: How do I save a filtered table as a new (separate) ta

[Guest]

....with the ability to add new records?

Thanks in advance
Amanda

 

[Nikos Yannacopoulos]

Amanda,

It's generally bad practice to have several tables of the same
structure. The general answer is: you don't. Keep it all in one table
and filter as required. Is there a compelling reason why you would want
to do that?

Nikos

 

[Joseph Meehan]

...with the ability to add new records?

Thanks in advance
Amanda

You could use a make table query filtering in the query. However the
real question is WHY? Normally it would not be a good idea to do that.
Access generally is faster and happier if you just re-filter it as needed
rather than having two tables. Two tables will also complicate things for
you later.

You can filter and sort your data using a query and keep the query.
Keep different queries for each set of data you want. Then when you add or
delete new data, you don't need to make adjustments to the data in many
different tables which are sure to get out of sync.