MySQL Forums
Forum List  »  Microsoft Access

Re: Access form property ORDER BY not working
Posted by: Larry Kinney
Date: March 02, 2006 08:36PM

In Access, separate the Order BY fields with a comma and enclose all within a single set of quotes, e.g.

"PropID, ClientID"

Additonally, on Access Reports the OrderBYOn property must also be set to True.

In a Microsoft Access project (.adp), the Order BY property is ignored.

One always has to set the order of records to be displayed in Access because with indexing, the order can generally be unpredictable.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Access form property ORDER BY not working
6840
March 02, 2006 08:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.