query first NN records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello there
is there any way to force a query or a report to give the first 10 for
example records of the whole results?
thanks
 
"First" is a squishy concept. What you think of as "first" may not
(probably does not) match what Access considered "first".

Your first step will be to order the data (use a query).

Then, you can use one of the query properties (TOP) to return only the
"first" 10 result rows.
 
i made some reports based on queries using ascending filter for the surname
field...it would be convinient if i could take the first 10 of 100 for
example that query giving...
 
As my earlier response pointed out (I hope), first sort, then use "TOP"
property.

Do this in a query, then base your report on the query.
 
Back
Top