displaying last/first n records where n is a variable (1 Viewer)

[ivanteo]

Hi, i'm trying to query the last/first n records of a table and n is a variable which is entered by the user in a form.
any help?
thanks in advance!

 

[David R]

SELECT TOP N....

You'll have to specify what the sort order is, and (I believe) build your query in VBA, since you can't pass variables directly from VBA to stored queries.

 

[ivanteo]

Thank you for your reply!
i'm not very familiar with VBA codes and was wondering if you could help me?

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum7/HTML/003318.html