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

[Birmangirl]

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