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

Dynamic Naming of Form Button 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Automatic Emails sent to my Contact Groups by Microsoft 1
need a form to auto date on table 2
Invoice database / report question. 7
Insert new photo album - photos are in reverse order 0
Change date order for comments field 0
DATE Calculations in pivot table 0

Top