- Local time
- Today, 22:26
- Joined
- Jul 9, 2003
- Messages
- 16,282
I think. Basically I have a query in Access that outputs some values, which I then need to calculate by subgroup in Excel,
I answered a question a while back where the user wanted to take subgroups out of an MS Access table and create a separate sheet for each subgroup in Excel. I found a piece of code by BTAB Developments, it was created by a former member here, Bob Larson.
This is a video showing it running:-
Make Hundreds of Excel Sheets From MS Access Table - Nifty Access
and there's more information about it on my website here:-
Make Excel Sheets From Access Table - Nifty Access
Excel Sheets From Access Table OP "avalve" asked this question on Access World Forums:- "Howdy! Let me make a small scenario. Let's say I have a table with fields CarMake/CarModel/Year/Color. What I am trying to do is to export the table to a single Excel Workbook with each CarMake having their...
www.niftyaccess.com
thought it might be the sort of code you can hack about to your hearts content!
Last edited: