CSHTech
asked on
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?
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?
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
mx
ASKER
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?
Saving the results of the filter by selection would be ideal - is there a way of saving it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
I know how to create forms and buttons, but could you point me in the right direction as to how to achieve this?
ASKER
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.
mx
I can achieve what I need by Saving as a Query - many thanks for your help.
mx