go to last record minus one?

  • Thread starter Thread starter TL
  • Start date Start date
T

TL

I am trying to do a search for the second last record in
this table. Is it possible to create a macro or a query
or code (whatever) to do a search in a form that will go
to the last record minus one? If so, how would I go about
it?

Thanks in advance for any help.
 
How do you define the "second-to-last" record in a table? A table has no
inherent "order" except the order that you impose on it specifically through
a query (other than the indices that the table may use for displaying
records in datasheet view).

Base a query on the table and use a sort order. Bind that to a form as the
recordsource. Then you can do a MoveLast action and then a MovePrevious
action (in a macro) or use VBA code to do similar steps to get to the
"second-to-the-last" record.
 
Back
Top