Specify Sort Order in Dynamic Query

M

MaryAnn

Thanks for reading -

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

Any help is appreciated.

MaryAnn
 
D

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