Access Note table in date order, when go to note form, dates are n
in [Tables]
|
Prev: Access 2007 Note table in date order, note form is not. What can I
Next: Unable to have multiple useres share database concurrently
From: Rachel Rollins on 10 Dec 2009 13:39 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
From: KARL DEWEY on 10 Dec 2009 14:14
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 |