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

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

KARL DEWEY

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.
 

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

Access Access Record Order 0
need a form to auto date on table 2
Invoice database / report question. 7
Table Design 1 to Many Relationship Question in Access 2007 4
Order of information in a form 1
Form Propery Order by 2
Add a date stamp to the note field of a custom form 1
Update form after note is made 4

Top