Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Access 2000...

Oct 26, 2004 2:25AM PDT

Too many expressions in order clause...

Anyone familiar with this error message?

Discussion is locked

- Collapse -
Re: Access 2000...
Oct 26, 2004 5:32AM PDT

SQL:
select ... from ... where ... order by ...

Either the syntax for the order by clause is invalid or there are really too many expressions/fields. Note that a query design view is just another way to look at an SQL statement.

Things to do:
- Press the Help-button in the error-message for more explanation.
- Look in Access help for information on Select, order by clause and limitations
- Try to work around the limitations.

If you need more help: post the full SQL-statement here.

Hope this helps.

Kees

- Collapse -
Addition
Oct 26, 2004 6:54AM PDT

In Query Design language the error message translates to "Too many sort fields". So the solution becomes:
1. Find out the maximum number of sort fields allowed.
2. Change your query. A good way seems combining sort fields.

For example: if you want to sort on Last_name, then First_name (two fields) you can just as well sort on Last_name + "," + First_name (one field). Note you need to use the nz-function if fields can contain Null.

Hope this helps, and post with more details if necessary.


Kees