Removing Certain Records from a Query and Report

  • Thread starter Thread starter Ambler
  • Start date Start date
A

Ambler

Hello,

I am using Access for a university assignment. I created a query to find
the most expensive items from my table. I have sorted the query results in
descending order by cost. For the assignment, the Report is supposed to show
only the top five most expensive items. How do I delete all the other items
from the query and report, but leave them in the tables?

Thank you.
 
Hello,

I am using Access for a university assignment. I created a query to find
the most expensive items from my table. I have sorted the query results in
descending order by cost. For the assignment, the Report is supposed to show
only the top five most expensive items. How do I delete all the other items
from the query and report, but leave them in the tables?

Thank you.
Click to expand...

Take a look at the TOP VALUES property of queries.
 
Back
Top