Solved How to set set Sort Order by Entry Date and Time? (1 Viewer)

JithuAccess

Member
Local time
Today, 06:22
Joined
Mar 3, 2020
Messages
297
Hello Guys,

I want to sort entries in my Form by Entry Time. So I have created a new field in the Table and set the current date and time as default value. Then I have make this Text invisible.

I want to display the latest Record when I open the Form.

Could you please let me know how to set this sort order in my Form?

Thanks
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:22
Joined
Aug 30, 2003
Messages
36,118
You can base the form on a query that applies that sort or use the Order By property of the form.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:22
Joined
Oct 29, 2018
Messages
21,358
Hi. Just as a reminder, in case it applies, the DefaultValue property only applies to new records. So if you have any existing records, those won't have the date and time information in that new field. Cheers!
 

JithuAccess

Member
Local time
Today, 06:22
Joined
Mar 3, 2020
Messages
297
Hi. Just as a reminder, in case it applies, the DefaultValue property only applies to new records. So if you have any existing records, those won't have the date and time information in that new field. Cheers!
Thanks a lot
 

Users who are viewing this thread

Top Bottom