Specify Sort Order in Dynamic Query

  • Thread starter Thread starter MaryAnn
  • Start date Start date
M

MaryAnn

Thanks for reading -

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

Any help is appreciated.

MaryAnn
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preferred way to do sort order - column in table, or specified in query? 3
Sorting in select query. manually 1
How to specify display order of query objects with Access 2007 1
Question on Sorting within a query 2
Dynamic sorting of listbox based on crosstab 2
Sorting Problem 4
Sort order by customer name not working in query 5
Passing Order By Parameter Not Working 3

Back
Top