Query

  • Thread starter Thread starter Kim
  • Start date Start date
Kim

Look in Access HELP for the "TOP" qualifier (as in "Show me the TOP 10...").
It's a property of the query, and if you are working in SQL, you can use
"SELECT TOP 10 ...".
 
Hi,

In the design view, if you have the property sheet open, click on the
top half portion of the designer, to get the properties of the query, and
spot "Top Values", change the All, by default, to 10. You also have to
specify at least one field with a SORT.

In SQL view, if you prefer, you insert the TOP 10 right after the
SELECT and before the first element of the list. You also use an ORDER BY
clause, if none is already present.


You are not obliged to do it in the SQL view AND in the graphical view,
make the modification in the view you prefer. Being in a newsgroup,
"graphical" instructions are generally not those you would see recommended
.... since all text solution (SQL view) are more applicable, given the
medium. :-)



Hoping it may help,
Vanderghast, Access MVP
 
I did what you suggested, but it will not run the report.
I waited 10 minutes to see if it would open and it kept
running and running I finally hit Cntl break to stop.

Is there another way?
 
Back
Top