Saving filter results as a table

M

Mark Watlock

Using Access XP.
Is it possible, and if so how, to save the results of
filter applied to a table as a separate table. Thank you
in advance.
 
A

Allen Browne

Easy to do with a query:

1. Create a query into your table.

2. Apply the same criteria.

3. Change it to a Make Table query (Make Table on Query menu).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Filtered view of Visio Chart 0
Sorting and filtering text 0
Format column widths from one table to a separate table on same page 1
Consolidation Table from Different Excel Tabs with Different Format 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Macro to copy table of contents to a new doc 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top