last row or record

[igg via AccessMonster.com]

there is no ID in this table.
table1:
col1 col2 col3
----- ------ -----
aaa bbb ddd
aab jjj fff
ccc qqq ppp

like to get this output:
col1 col2 col3
----- ------ -----
ccc qqq ppp

 

[naveen prasad]

sorry to buttoning in between...

try this...

create form using table, and in form on load properties.

DoCmd.GoToRecord , , acLast

regards

 

[John Spencer]

Unless there is something in the data that tells you which record is the LAST
record you are out of luck. Records are unordered when they are stored in the
database.

Perhaps you can get what you want with a totals (aggregate) query that uses
the LAST operator.

SELECT Last(Col1), Last(Col2), Last(Col3)
FROM [YourTable]

That will return the last record retrieved by the query, which is often (not
always) the last record entered into the table.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County