Limit the query output

  • Thread starter Thread starter Palia Weel
  • Start date Start date
P

Palia Weel

I am a collage student which new in Access.

Currently I am doing an assignment. It is use the Access to store the
student data(personal and academic). I already built the table and the first
simple query, but I do not know how to limit the out put of the query.

The question is: show the top 5 student in academic result.

I can show all the academic result and sort it, but how to limit the output
to show only the top 5?
 
Look at the query properties while in design view and see if something
doesn't jump out at you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top