When I running a query to an excel spread sheet and I come to a level break I want to create a double line for a total for that item before creating the next item. Can I do this in a query?
Advanced Beginner
Windows 7 64bit 
Access 2010 32bit
When I running a query to an excel spread sheet and I come to a level break I want to create a double line for a total for that item before creating the next item. Can I do this in a query?
VIP
Windows Vista Access 2010 32bit
No, that is excel formatting.
VIP
Windows 7 64bit Access 2010 32bit
Try exporting a report that uses Grouping & Sorting features with aggregate calcs in group footer section.
Reports don't always export nicely but might be good enough.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VBA Text import with double lines for one record
Column Lines
Posting Permissions
Reply With Quote