Order By not working under IIS7/Access database

S

Steve Bottoms

Simple query, ordered by dDateField desc, cCharField asc, nNumericField asc.
Irrespective of whether I have the "ASC" keywords in there, it's behaving as
though the query is specifying DESC on all three order fields. Anyone
notice this in IIS7? Tried multiple variations, no go.

Thoughts?
Steve
 

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

Order by not working 5
Limiting results from one side of a join conditionally 1
Error 3420 Object invalid or no longer set under Vista 7
SELECT TOP 1000 not working - returns 1173 results with ORDER BY 2
Sort on Random Number field not working 3
Nested JOIN clauses - order of precedence (Access 2007) 2
Functions not working in Access 2007 Queries 9
"order by" issue after compact database 11

Top