Report Sorting

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...
 
G

Guest

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!
 
L

Larry Linson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenated field in a report is not sorted 1
Sorting and Grouping 2
Sorting & Grouping Problem 4
Coordinating the sort order in a report with the underlying query 2
Sorting in a report 7
Sort by Ascending in complicated Report 1
Sorting by one field, Grouping by another? 1
Report - Sorting and Grouping 1

Top