Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Saving the result of Access Filter by Selection

I've got a table which contains 20,000+ records and regularly filter using right-click > filter by selection - usually two separate fields to get the final results I need. This is a quick and easy way for me to get the info I need at the time.

I know that the results of this filtering are temporary but I now need to print the results of the filtering by selection, as labels for mailshots. The problem is that I cannot seem to find a way of saving the results as a separate table, so that I can print labels directly in Access (or for transferring to Word if I need to edit the labels if necessary).

Can anyone advise me how I can save the results of this filtering separately from the original table?



0
CSHTech
Asked:
CSHTech
  • 4
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
One way is to create a Query against that table, and do the sorting/filtering in the query ... and of course saving the query for quick recall.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Example - see image

mx
Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
btw ... at the Table level, this is no way I know of to Save the filtering/sorting that you have done by Right Clicking. It can be done, with VBA code at the Form level, but that's a different story.

mx
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
CSHTechAuthor Commented:
Thanks for the reply DatabaseMX, unfortunately other people in the office will also need to perform this task, so ideally I need to keep it as simple and as quick as possible, preferably without going into individual queries.

Saving the results of the filter by selection would be ideal - is there a way of saving it?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"is there a way of saving it?"
Not at the table level. And really, your users should not be working directly at the table level because it is VERY easy for people to screw up data in doing so.  That is the purpose with at minimum - a read only query and better yet, a User Interface using Forms.

 I suppose I should clarify that ... with the table open in datasheet view, if ... after you right click and filter etc, then File>>Save ... Access will ask if you want to Save the Changes, because Access considers Filtering and Sorting a 'design' change. So, you *can* do this ... and that will remain in effect when the table is opened again. BUT ... another user can easily override that also.

mx

0
 
CSHTechAuthor Commented:
So presumably a form with two drop down list boxes for each relevant field (in the original table) and a search command button would be the safest bet? The results could then be saved separately?

I know how to create forms and buttons, but could you point me in the right direction as to how to achieve this?
0
 
CSHTechAuthor Commented:
I suppose I should clarify that ... with the table open in datasheet view, if ... after you right click and filter etc, then File>>Save ... Access will ask if you want to Save the Changes, because Access considers Filtering and Sorting a 'design' change. So, you *can* do this ... and that will remain in effect when the table is opened again. BUT ... another user can easily override that also.

mx

I can achieve what I need by Saving as a Query - many thanks for your help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now