riddle me this (1 Viewer)

[Tfa]

well since i am here a have a question
a have a report grouped by in only one level
this report is outputed to excel through docmd.outputto
now here comes the million dollar question
can i remove the group by before i export it to excel ?

 

[NauticalGent]

Doesn't appear to be a way to remove/modify grouping at run-time...

This may help:

https://access-programmers.co.uk/forums/showthread.php?t=221786

 

[Minty]

Nope but you could output the query behind the report - which I would assume wouldn't have the grouping?

 

[Tfa]

yes i could but that way i could lose the filter that might be applied to that report

 

[Minty]

Why not apply the same filter to the query ?

 

[Tfa]

well i did something else
I made a new report opened hidden
export the new report into excel
i also though about filtering the query
but i abandoned the idea for 2 reasons
first one there are more columns in that than i want to show
and second this way i can keep the format