Thread: Access 2003
View Single Post
Old 08-07-2009   #6 (permalink)
Rhese


Vista Business 64bit SP2
 
 

Re: Access 2003

Hi Witch-King-of-Angmar,

I just came across your post. I do a ton of work in Access 2003 and, now, Access 2007 . From your screenshot, I'm going to guess that you have an index on the [Publisher] field. Records are displayed in ascending order of their indexes. The latest record has nothing in the [Publisher] field so it jumped to the top.

You certainly can (and should, if that's how you want to view the records) add a [Read_On] or [Date_Added] date field and give it a default value of Now() so that whenever you add a new record, that date field will be automatically filled in with the current date and time. Make sure that this field is indexed and is the first indexed field and the table should automatically sort by it.

Hope that helps.

--Rhese
My System SpecsSystem Spec