So I have a formatted report that when I have the report open in Report View and go up to External Data>Export To Excel it exports fine and keeps my report groupings. If I use the DoCmd.OutputTo acOutputReport command using a button on the report it exports fine, but the groupings all have the same group name. The report has different names in the groupings.
I have attached samples of the Excel sheets as they come out of Access so you can understand what I mean.
Thanks for any help you can give me on this.