Sorting Multilple fields in a report

G

Guest

I am trying to sort multiple time/date fields in a report, but the
"Sorting/Grouping" tool does not allow this. For example, I have several
campus visit time/date fields in my form, and I want to put them in a report
that is essentially an itinerary for the visiting student that puts their
schedule for the visit in time/date order but I can't seem to come up with an
expression that provides for this. I tried the following in the
"Sorting/Grouping" window:
=OrderBy([Campus Tour Time],[Info Session Time],[Interview Time],[V & PA
Tour Time],[Lunch Time],[Academic Advising Time],[Coach Time],[Fin Aid
Time],[Professor Time])
But I get an error message. Any suggestions??????????????????
 
K

Ken Snell \(MVP\)

Don't use Order By expression in the Sorting and Grouping window. Just put
each field in a separate row, in the order listed in your Order By clause.
Top field in Sorting and Grouping will be sorted first, then the second
field, etc.
 

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

Sub-Report Won't Sort 2
Sort Multi Time Fields 14
Report sorting 1
Report Sorting 2
Selectable Report Fields ? 1
Sort on report at run time? 2
Sorting & Grouping Problem 4
Sorting a Report Based on Criteria 2

Top