How do you read back the last 100 data points from Access 2003?

[Guest]

Hi,

I know a little about databases...but what I am trying to figure out is how
to read back last 100 data points I saved in an Access 2003 database for a
particular parameter in a table. Can anyone help me out?

Thanks.

 

[Guest]

Build a query and use the "Top Nth" Property

 

[Jeff Boyce]

Mike

You may find out that how Access counts "the last 100" and how you do are
not the same.

Unless you can tell Access exactly how to sort the records (e.g., by a
date/time field entered in each record), you will not be able to get the
"last 100". Or at the least, not consistently, since Access will make its
own determination unless you tell it otherwise!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Mike

You may find out that how Access counts "the last 100" and how you do are
not the same.

Unless you can tell Access exactly how to sort the records (e.g., by a
date/time field entered in each record), you will not be able to get the
"last 100". Or at the least, not consistently, since Access will make its
own determination unless you tell it otherwise!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks Jeff...