Automatically sort list view form by date (descending)

[Olikun]

Hello,

a new question.

How can I set it up so that the list view of the form is automatically sorted.

I only have 1 line (date) in the list

I want the current date to be at the top.

I know I can sort the list manually with one click, but I want it to happen automatically.

Is that possible?

[kev1n]

Add an ORDER BY your_date_column DESC in the Browse SQL

Code: Select all

SELECT * FROM your_table ORDER BY your_date_column DESC

[Olikun]

works perfect

thanks