Sorting and grouping for more than 10 fields???

[wrek]

Access reports currently limit you to sorting a maximum of 10 fields...*

Is there a way in VBA to sort by more? (I have 11)

There is the option that I use a subreport which divide the fields etc...but I'm wondering if theres a workaround to this. Also, sorting the query recordset, doesn't translate onto the report...

Thanks.


(and I know, sorting by more is indicative of poorly structured databases...believe me when I say I have no choice here, my manager is a micro-managing self-professed IT genius...who is a big proponent of 'flat tables' )

 

[wrek]

Now why didn't I think of that?

(11,000 more posts and it'll probably all click)

Thanks Pat, that should work great...

(and 'he' doesnt have pointy hair....SHE does)