How do I display my last 15 entries in Access 2002?

P

prphan

I want to display the last 15 entries I have made using a form in Access
2002. It appears I want to do a sort, but how do I limit it to the last 15?
 
K

Kevin3NF

You will need to create a query using the TOP clause, as well as an ORDER BY
on the column that defines what "last" means (like createdate, invoicenum,
etc.)

Something alotng the lines of:

SELECT TOP 25
FirstName, LastName
FROM Students
WHERE GraduationYear = 1994
ORDER BY GradePointAverage DESC;


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Top