Access stores records like a barrel of bricks, no set order. You should not
view records at the table level but via a query, form or report and order the
records in them.
--
Build a little, test a little.


"Rachel Rollins" wrote:

Help, I have checked everything and can't find the solution. I have a
database that has date visited on the form. I want the last date visited
displayed at bottom of form, and prior visits in order above. Anyhow, when I
run the note table everything is in proper date order, however, when I put
the notes in the note table, and look at it from there, they are NOT in date
order. Has anyone had this happen to them? I will still be checking
things, but I think I need some help on this quirky one. Thanks.
--
Rachel Rollins