Limiting records returned in a query

G

Gonzosez

I have a query that is called by 2 different reports.
1. is a dataview and all records are required.
2. is a graph only 10 records are required.
How can I limit the records returned to 10?
Thanks
 
G

Guest

You will need two queries. In query for the graph, change the query's SQL
from Select to Select TOP 10. For TOP to work, the query must be sorting the
records in descending order. Also if there is a tie for the 10th position,
Access will return more than 10 records.

If you don't know how to change the SQL, right click in the QBE table area
and go to Properties. Change Top Values to 10.
 

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

Similar Threads

Limit number of records returned from query 5
Radio Button Value In Query 3
Query Parameter using multiple options 0
Count number of query records while in a form 1
Circumvent "At most one record can be returned by this subquery"error 4
Wrong data returned when using Year function 4
Limit to Records in a drop down box? 2
Access Dcount (multiple criteria) 3

Top