Choose Command in Microsoft Access
The SQL Choose command is a great function for both visual basic
and SQL queries. In our downloadable example we demonstrate using the
choose function to allow the user to select the sort order for a query.
This query can be used as the record source for a report. The end result
of using the choose command is a dynamic order by clause for the query and the
report output.
You can use the choose command in all parts of an
SQL query except the From Clause ( I think ). We hope to include the
choose function examples for the select clause in the near future. You can
review further discussion and example of the
choose command in the SQL Select
clause in our
Developer Tutorials section.
Use this link to
download and run our
SQL Choose Command Example
Download.
