 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / December 2005query first NN records
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.  SignatureRegards Jeff Boyce <Office/Access MVP> > 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 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... > "First" is a squishy concept. What you think of as "first" may not > (probably does not) match what Access considered "first". [quoted text clipped - 8 lines] > > example records of the whole results? > > thanks 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. SignatureRegards Jeff Boyce <Office/Access MVP> > 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 [quoted text clipped - 12 lines] > > > example records of the whole results? > > > thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.