I use Offoice 2007
I have a weird behavior of report export as excel
The Access report is grouped by a field criteria (county)
When opening in access, the report is displayed properly
Group element 1
Item 1
Item 2
Item 3
Group element 2
Item 1
Item 2
Item 3
Group element 3
Item 1
Item 2
Item 3
Group element 4
Item 1
Item 2
Item 3
Nice and smooth
But if I try to export the report in excel, the outpud displays corectly only the first 2 groups
For all othe groups, instead of changing the grouped-by element, it will remain the same starting with the third group element
Group element 1
Item 1
Item 2
Item 3
Group element 2
Item 1
Item 2
Item 3
Group elemen 2
Item 1
Item 2
Item 3
Group element 2
Item 1
Item 2
Item 3
Please advise