Access Note table in date order, when go to note form, dates are n

  • Thread starter Thread starter Rachel Rollins
  • Start date Start date
R

Rachel Rollins

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.
 
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.
 
Back
Top