Hi John, There are several ways to do this. Richard has 2 videos that I recommend you watch that will do the job for you.
https://www.youtube.com/watch?v=I3AQVZCEHmI - thisfoundation video gives you a good foundation

https://599cd.com/blog/display-article.asp?ID=1814&X - this extended cut shows you a sure fire method of doing waht you want.

There are other ways such as appending to a temporary table and then printing the previously selected records, deleting the temp table etc.
Try Richards approach as show in the extended cut. Come back if you need additional help.  John