Question by  fb3 (29)

How do I sort by expression in Microsoft Access?

I'm using MS Access, and can't find the tool I need to sort by expression. How is this done?


Answer by  gigo (1706)

Go to the SQL console and use ORDER BY. With CREATE VIEW You can pipe it in an extra table. For example you can use create view viewname select col1, col2, col3 from example_table where col1 = 3 and col2 = 5 order by col3. In the new created view you have what you need.


Answer by  gigo (1706)

Just use the SQL button. There you have the possibility to write down for example SELECT * FROM table1 WHERE a = 3 AND b = 5 ORDER BY a. With DESC or ASC you can change the sort direction.


Answer by  Christian9247 (5042)

Open your database in your HTTC Access. Open the report called Design View. Then click sorting and grouping. Once in the dialogue box type the name of the expression. You can have up to ten fields.


Answer by  emersonblue (14)

Open your database in Access, open the report in Design View. Then click on the View menu, click Sorting and Grouping. Once the dialog box appears select a field name or type an expression. You can sort up to 10 fields/expressions in a report. The first row is the first sorting level and so on from each row following.

You have 50 words left!