How To Export Access Reports To Excel Maintaining Grouping Functionali

[mordja]

Hi,

Im just wondering if anyone has any suggestions as to how go about exporting a report from access to excel and maintain grouping functionality. The only aggregate function which is supposed to work is Sum. Is there any other way in which to export a report of moderate complexity and retain all calculated values ?

Thanks
Izac

 

[batteam]

You might be better off just having the data go directly to Excel and bypass the Access reporting altogether.

Use the 'TransferSpreadsheet' function in Access to do this. MS Access Help can offer you good adivce on this works.

Hope this helps.