Results 1 to 2 of 2
  1. #1
    mylesg is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    1

    Deleting filtered data

    I joined two tables via a query- and ended up with a query output of about 200K records. I then quick filtered a few conditions in some of the variables- and now the query is showing 50K records (this is what I want).



    When I export the query or try to create a new table with just those 50K records- end up back with the unfiltered 200K records. How can I create a exported file or even another table that just has the filtered data (50K) in it?

    I also tried to filter the two tables before the query- but still end up with the 200K.

    Thanks

  2. #2
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    I don't do much filtering so I might be missing something, but I think you will need to modify your query to provide the desired data without filtering. Then you can just export the query results.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Open form to filtered records
    By ducecoop in forum Access
    Replies: 3
    Last Post: 10-22-2010, 10:53 AM
  2. Replies: 1
    Last Post: 07-19-2010, 09:50 AM
  3. Filtered Report
    By Desstro in forum Reports
    Replies: 3
    Last Post: 06-18-2010, 09:09 AM
  4. Deleting certain data
    By swindmiller in forum Queries
    Replies: 3
    Last Post: 02-17-2010, 10:39 PM
  5. Filtered Print Query
    By Lupus in forum Queries
    Replies: 0
    Last Post: 08-17-2007, 02:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums