Query

  • Thread starter Thread starter Test
  • Start date Start date
T

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!!
 
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.
Click to expand...

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
 
Back
Top