Orderby property

[Chris McArley]

I am attemting to set the OrderBy property on a query
definition (as opposed to using an OrderBy clause in the
SQL). While I can get the query to return the
information in the correct order in Datasheet view - if I
then attempt to use that query as a Rowsource in my
listbox it will not apply the OrderBy property. Have I
missed something.

 

[Michel Walsh]

Hi,

The order by query property is about its data view representation ... if
you wish it somewhere else, you put it in the SQL statement (or in the
"Sort" line of the grid).



Hoping it may help,
Vanderghast, Access MPV

 

[Guest]

Thanks Michel - I thought I may have been misusing it -
I'll get around it by updating the querydef.sql property
and updating that to include the valid orderby at runtime.

Thanks.

Chris