Topic: Sort tables by button in SQL
Hello everyone, I would like to know how to sort a table in alphabetical order by a print button in SQL.
Is it possible ?
I have a list here:
---------------------------
My Visual Database → General → Sort tables by button in SQL
Hello everyone, I would like to know how to sort a table in alphabetical order by a print button in SQL.
Is it possible ?
I have a list here:
---------------------------
Hi,
If you are using an SQL query, then use the construct to sort
SELECT Field1, Field2, Field3 FROM Table WHERE ... ORDER BY Field2 ASC
where you use any field or multiple fields and sort priority
SELECT Field1, Field2, Field3 FROM Table WHERE ... ORDER BY Field3 DESC, Field1 ASC
ASC asceding sort or use DESC - desceding sort
If you use other possibilities, please indicate what exactly or attach an example.
Hello sdpc, Hello Sparrow
Tu souhaites ce tri pour affichage dans un état (*.fr3) ou simplement affichage visuel de la grille ?
You want this sorting for display in a report (*.fr3) or simply visual display of the grid. ?
JB
Super Moineau, the SQL code works wonderfully.
Thanks a lot
Sabine
My Visual Database → General → Sort tables by button in SQL
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi