copying/exporting results of a table with filter applied?

  • Thread starter Thread starter RP
  • Start date Start date
R

RP

Hello - I need to whittle down a large table to and have a filter applied,
but I can't figure out how to "crop" the table. That is I would like to copy
the resulting records, but the copy function is not available. When I export
it saves the entire table and not the filtered set. Any ideas?

Thanks

Rich
 
I have that. But I need to delete the records that don't match the query
criteria. Thus I was trying to apply the query and copy the results.
 
Are you talking that you need to delete the records that don't match the
query from the table, or simply that you only want to export those records
that meet the query criteria?

If the former, write a Delete query that uses the inverse of the select
criteria.

If the latter, you can export the query, rather than the table, and only
those records that the query selected will be exported.
 
Thanks. I finally exported to Excel and then back in to access. I kept
trying to export to another MDB and it would just save the query definition.
:)
Cheers

Rich
 
Back
Top