report.orderby doesn't work?

[hollsys]

Using Access 2002, I have reports that have no sorting or
grouping defined in the report format; instead I let the
user select a sort order on the fly, with Ascending,
Descending qualifier.

When the sort order I'm applying has more than one fields
in it, and the DESC qualifier, the sort order just doesn't
get recognized. That is,
This WORKS:
strSortOrder = "TTD DESC"
me.orderby = strsortorder
me.orderbyon = true

this DOESN'T WORK:
strSortOrder = "TTD, Lastname, FirstName DESC"
me.orderby = strsortorder
me.orderbyon = true

Can anyone tell me why? Should I just stay away from
orderby altogether?

 

[Duane Hookom]

I would stay away from the OrderBy in favor of setting the sorting and
grouping. Check Allen Browne's page
http://members.iinet.net.au/~allenbrowne/ser-33.html.

 

[Guest]

thanks for the input - will this work if the report is in
a .mde?

 

[Duane Hookom]

Definitely

--
Duane Hookom
MS Access MVP
--

thanks for the input - will this work if the report is in
a .mde?