Telling a query to return last 3 rows

[justlearning2003]

Hey everyone,

I have a query setup and I only want to return that last three rows of data from the table.
Anyone have any advice on how to set this up?
I am aware of the the SELECT TOP 3 but not sure if it is possible to just bring back the last 3 records.

Thanks

 

[cghoga]

try setting your sort order to Descending (or the opposite of you current sort order) and then select the Top 3.

hope this helps.

 

[legos]

Probly not the best way, but this code will make a second table with the last 3 records and you can query that

sub writetable ()
dim db as database
dim rst1 as recordset
dim rst2 as recordset

dim count as interger

set db as currentdb
set rst1 = db.openrecordset("select * from Table1Name&quot
set rst2 = db.openrecordset("select * from Table2Name&quot
rst1.movelast
rst1.moveprevious
rst1.moveprevious

for count = 0 to 2
with rst1
.addnew
rst2!fieldname = !fieldname
.update
next count
end Sub

Durible Outer Casing to Prevent Fall-Apart