Victor Kimura
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.articleDi rectoryID= many.artic leDirector yID) ON articles.articleID=many.ar ticleID) ON clients.clientID=many.clie ntID) INNER JOIN articleBody ON many.articleBodyID=article Body.artic leBodyID
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.
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.articleDi
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, peter57r. Thank you, NerdsOfTech.
under the order by property you can define your primary sort
:)