This sample database from Nifty Access demonstrates how you can take different sets of records from an MS Access table and show each different set on a separate spreadsheet page in Excel.
There are full instructions on the Free Version in my Blog:-
Go there to see how to get the Free Version up and running. If you have any problems post your questions in this thread!
One of my customers had a minor problem with the original code, I fixed it, and have uploaded an update. I left the original zip file suffixed with (1a) and added a new zip file suffix with (1b)
You've purchased this product
See it in your libraryView in Library
We charged your card and sent you a receipt
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Good news! Since you already have a Gumroad account, it's also been added to your library.