ORDER BY clause for Forms
Posted on 2009-05-01
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.