Specify Sort Order in Dynamic Query

[MaryAnn]

Thanks for reading -

How do I specify a sort order on a dynamic query by form?

Any help is appreciated.

MaryAnn

 

[Duane Hookom]

You could place a calculated column in your query:
SortBy:Choose([Enter 1-First Name 2-Last Name 3-City 4-Zip], [FirstName],
[LastName], [City], [Zip])
You could substitute other expressions for the parameter.