If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Note table in date order, when go to note form, dates are n
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 |
#2
|
|||
|
|||
Access Note table in date order, when go to note form, dates are n
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 |
Thread Tools | |
Display Modes | |
|
|