New Record At the Top of the List

[J]

All,
In a subform for notes I order by date DESC. This show my notes from Newest
to oldest. Which makes sense for our business purposes. We always want to
see the newest notes first. We also need the new note fields to be at the
top of the list. Access 2003 puts the new note fields at the bottom. Does
anyone know how to move it to the top of the list.

 

[Duane Hookom]

Records in tables are in no particular order. Since this is a reports news
group, I think you only need to open the sorting and grouping dialog, select
your NotesDate field and set the sorting to Descending.