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?