report.orderby doesn't work?

  • Thread starter Thread starter hollsys
  • Start date Start date
H

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?
 
Back
Top