New Record At the Top of the List

J

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Continuous Forms blank recored at top 6
Outlook 2007 show newest message problem 0
Auto-insert newest note at TOP of a ON 2007 section's note-tab lis 9
Change date order for comments field 0
Macro to filter on most current date. 5
changing numbered lists to 'normal' text 1
Date Frequency 1

Top