I have about 20 queries that I'm exporting to MS Excel 2010 in this example. When I run the queries just in Access, I have totals for selected columns, selected on the home tab. When I export them, the totals do not get exported. I've brute forced it in the past by creating a temporary table with the query, then appending a totals line to it and exporting that table to Excel.
An example of the VBA liine I have in the module to export is:
DoCmd.TransferSpreadsheet acExport, 10, "TDREPC Summary", "Q:\production\isaac\Time by Date Range by Employee by Product Category.xlsx", True
An example query is:
SELECT [TDREPC Summary- prep].Last, [TDREPC Summary- prep].First, [TDREPC Summary- prep].AssociateNumber, [TDREPC Summary- prep].[Total min], [TDREPC Summary- prep].[Med Total], [TDREPC Summary- prep].[Bard Total], [TDREPC Summary- prep].[Micell Total], [TDREPC Summary- prep].[SII Total], [TDREPC Summary- prep].[STI Other], [TDREPC Summary- prep].Warehouse, [TDREPC Summary- prep].[Training Total], [TDREPC Summary- prep].[Overhead Total], [TDREPC Summary- prep].[Total Production], [TDREPC Summary- prep].Payroll, [TDREPC Summary- prep].[Total Factory], [TDREPC Summary- prep].Quality, [TDREPC Summary- prep].Total, [TDREPC Summary- prep].Delta
FROM [TDREPC Summary- prep]
ORDER BY [TDREPC Summary- prep].[Med Total] DESC , [TDREPC Summary- prep].[Bard Total] DESC , [TDREPC Summary- prep].[Micell Total] DESC , [TDREPC Summary- prep].[SII Total] DESC , [TDREPC Summary- prep].[STI Other] DESC , [TDREPC Summary- prep].Warehouse DESC , [TDREPC Summary- prep].[Training Total] DESC , [TDREPC Summary- prep].[Overhead Total] DESC;
MS Access 2010, SP2 MSO, 64 bit
What am I missing for a more elegant solution? Thank you in advance for any suggestions.
Buck Crouch
Posted by: Buck7@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar