Link to home
Start Free TrialLog in
Avatar of Victor Kimura
Victor KimuraFlag for Canada

asked on

ORDER BY clause for Forms

Hi,

I created a form using the wizard and I believe it's based on one the queries I created. I can't really recall as I'm just learning access. In the query I added an ORDER BY clause and it displays properly in the proper order;however, the form does not conform with the ORDER BY clause of the query. How can I edit the form to use this ORDER BY clause?

SELECT articles.*, articleDirectory.*, clients.*, many.*, articleBody.*
FROM (clients INNER JOIN (articles INNER JOIN (articleDirectory INNER JOIN many ON articleDirectory.articleDirectoryID=many.articleDirectoryID) ON articles.articleID=many.articleID) ON clients.clientID=many.clientID) INNER JOIN articleBody ON many.articleBodyID=articleBody.articleBodyID
ORDER BY many.ID;

I find ms access does not seem to conform to the SQL standards - so many brackets and kind of confusing when one looks at the statement. Just a thought on it.
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Goto your form properties
under the order by property you can define your primary sort

:)
Avatar of Victor Kimura

ASKER

Hi peter57,

I see the OrderBy in the Form's property. It's just blank. Is there supposed to be a drop-down menu to select different fields to sort by?
No. Actually all you need to do is specify the field name there
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you, peter57r. Thank you, NerdsOfTech.