Sorting a report

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

I currently have a form where users enter in parameter
values for a report. How can I allow the same user to
select what field to sort the report on.
 
I don't care for uncontrolled prompts/parameters but you can use a
calculated column in the query:
SortBy: Choose([Enter 1-Last Name, 2-City, 3-Zip], [LName], [City],
[ZipCode])
Then set your sorting and grouping in the report to the SortBy column.

Allen Browne's site has a better solution
http://members.iinet.net.au/~allenbrowne/ser-33.html.
 
Back
Top