microsoft access report export to excel -

i have table following structure:

maincat    subcat  name    description main cat 1  sub cat 1   name 1  description 1 main cat 1  sub cat 1   name 2  description 2 main cat 1  sub cat 2   name 3  description 3 main cat 1  sub cat 2   name 4  description 4 main cat 2  sub cat 3   name 5  description 5 main cat 2  sub cat 3   name 6  description 6 

i have created report works fine use "group on" @ column maincat , subcat. have possibility export contend excel, , should structured this:

 main cat 1   sub cat 1    name 1  description 1 name 2  description 2 sub cat 2    name 3  description 3 name 4  description 4 main cat 2   sub cat 3    name 5  description 5 name 6  description 6 

any idea how create report or else there can in ms access?

maybe missed reporting desired structure shouldn't big problem. put name , description on detail-layer , configure 2 grouping-layers mentioned in post.

exporting reports access excel little tricky. although build-in-function exporting excel nightmare (compared other reporting frameworks) , not export formatting @ all, there 2 useful things notice:

1. the export can invoked code ('docmd.outputto')
2. it exports grouping structure spreadsheet

by collapsing/hiding groups bottom top , using 'range.specialcells(xlcelltypevisible)' can manage apply different formatting styles cells of individual layers. tasked creating formatted excel-export few years ago , hit 2 significant limits approach:

1. .specialcells rather slow command internally loops on sheet
2. the number of groups within 1 grouping-layer can created in excel is/was limited 8000-something (office2k3 then)

in practice had huge a3-financial-report 6 grouping-layers export did perform on 50.000 records in 20- 25 field-query.