Full Version: Multiple fields for orderby property
UtterAccess Forums > Microsoft® Access > Access Forms
gtsolano
How do you enter in multiple fields in the orderby property? I want to sort by [lastname] and [apptdate].
vtd
OrderBy = "[lastname];[apptdate]"
You may need to change the list separattor ";" depending on your Reginal Settings ...
gtsolano
I tried the above and neither of the fields is sorted. I can do one or the other but not both. Any suggestions?
vtd
Have you tried comma (,) instead of semi-colon(wink.gif?
It is usually one or the other depending on the language /egional settings (???)
gtsolano
That did the trick! Thanks so much.
vtd
You're welcome ... Glad to help ...
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.