Query

[Test]

Hello!
I'm new to Access and what I'm about to ask may be very
simple and basic.
I have a table (AA) with an autonumber column (aa).I need
a query to get the last row of table AA, or at least the
value of column aa of the last row of AA.
Any help will be appreciated.
Thanks in advance!!

 

[Tim Ferguson]

I have a table (AA) with an autonumber column (aa).I need
a query to get the last row of table AA, or at least the
value of column aa of the last row of AA.

select max(aa) as LastValue
from AA


assuming that it's an incrementing autonumber. If it's a random one, then
you'll need a sorting field like a datestamp to find the maximum of.

HTH


Tim F

 

[Test]

Thanks a lot!!!