Report Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read through several threads but still can't figure out my report's
sorting delimna. I'm trying to sort first by ascending Date, then by
ascending Time. The Date field is sorted nicely, but the Time field seems
random. I've set the sort order in the underlying query and also in the
Sorting and Grouping tool. But, no luck.
Would someone be able to instruct me with a VB code that might work? The
fields are [tblwodDate] and [tblwodStartTime].
Thank you...
 
Never mind! I'm dumb. I have two similar fields from two separate tables
and was trying to sort by the wrong one. My bad!
 
Just a note for the future: the sort order in the underlying query is
completely ignored in Reports; only the sorting specifie in the Report's
Sorting and Grouping has any effect.

Larry Linson
Microsoft Access MVP
 
Back
Top