There are 12 tables every month of the year, through this query a list of these tables is displayed, but you need to sort them by date ie. January, February, etc. For now, it is displayed only in alphabetical order, how to strictly indicate in what order the tables should be displayed.

SELECT mSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") And (Left$([Name],1)<> "_") And (MSysObjects.Type)=5

So does not work

 SELECT mSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1) <> "~" ) And (Left$([Name],1) <> "_" ) And (MSysObjects.Type)=5 ORDER BY FIELD (mSysObjects.Name, "Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь")
  • Add a calculated column that will assign a month number to the corresponding month. But this column and sort. - msi
  • good idea, thanks - NightTray
  • just like in mSysObjects, add a column, and I don’t think that this is a good idea) as a varant, edit the ID field - NightTray
  • Not to the table, but to the query using the IIF function. - msi
  • IIF will be too cumbersome. Switch better suited. Better yet, add a label with the matching name and number, associate it with an existing query, by number and sort it. - Sergey S.

0