Selecting the last value of the table and show

[dada]

can anyone tell me the sql query to be use to select the last record of a table? thanks in advance!

[ajetrumpet]

use the LAST() function

[dada]

mind giving an example about it? hmm..

[ajetrumpet]

dada,

here is some friendly advice. do some research on how to "basically" operate access. I've noticed you post a lot of questions here and you might get "more bang for your buck" if you just took the plunge and studied the program for a couple hours instead of posting multiple questions here that can be answered that way alone. Just a thought for you.

I say that because questions like this are very basic. LAST() is a built in function in this program. Look it up in the help menu to see the arguments. Example in a query:

SELECT LAST([field])

TECH ON THE NET is a great resource for functions. e.g. - http://www.techonthenet.com/access/functions/