I had not seen a response to this query so will provide an answer to your query.
The first thing to do is to sort the field in question by descending order. If you want to see all the numbers with the top five at the top then do nothing. If you want just the top five numbers then you may select this on the Query Design Toolbar. To the right of the Totals icon (the one that looks a funny E) is a combo box that says "All". This is where you can enter the number of records you wish the resulting query to provide. Glenn P. Jones -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Michelle Sinsel Sent: Friday, 04 November, 2005 1:42 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Access 2000 Report Set what to 5? --- In AccessDevelopers@yahoogroups.com, "Crosier, Dawn" <[EMAIL PROTECTED]> wrote: > > Base your report on a query. In the query design window, there is the > ability to select 5. By default it says All. You can set it to any > number you want. > > > Dawn Crosier > Application Specialist > "Education Lasts a Lifetime" > > This message was posted to a newsgroup. Please post replies and > questions to the group so that others can learn as well. > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Michelle Sinsel > Sent: Friday, November 04, 2005 10:44 AM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Access 2000 Report > > Is there a way to set a report up in Access 2000 where it will sort and > bring the highest number to the top. Right now I have to go thru many > pages just to pull out the top 5. Didn't know if this was doable or > not. > > I hope this makes sense. > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
