Sorting and Grouping variable 2

[Digsys]

I want to print a report and change the sorting and grouping variable. Sometimes I sort on the field Street and sometimes on Surname. I have tried using a global variable with no success, and cant seem to get a function to retrieve the string to work. Any suggestions

 

[THWatson]

digsys
Have a look at this site and see if it helps. It shows how to use Select Case to establish the sort order at run time.

http://members.iinet.net.au/~allenbrowne/ser-33.html.

Tom

 

[scriverb]

Great link Mr. Watson. Have a Star. This question has been asked a number of times lately and this should help others.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[Digsys]

Thank you THWatson, the solution is exactly what I was looking for