Sorting Multilple fields in a report

[anj]

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

 

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