It's in the query, not the report. Tobi
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of kbuske1 Sent: Wednesday, July 13, 2005 12:33 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Limit Records in a Report Ok, I changed my report based on the Query I built from the table, but I still dont see the "Top Values" tab in the properties on the report design view. Am I in the wrong place? --- In AccessDevelopers@yahoogroups.com, "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > You need to use a query behind the report for this method; "Top Values" is a query property, not a table property. It's good practice, anyway, to build reports on queries rather than tables. Simply create a new query, put the table in and pull down all the fields that the report needs. > > Tobi > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of kbuske1 > Sent: Wednesday, July 13, 2005 12:16 PM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Re: Limit Records in a Report > > > I'm using a Table to build my report. Does this still make it > possible to show the top 6 values. I'm not seeing the "Top > Values" ,in the properties section, that you wrote about. I could > use a little more specific help if you can. > > Thanks, > ~Kyle > > > > --- In AccessDevelopers@yahoogroups.com, "Hoffman, Tobi K \(DYS\)" > <[EMAIL PROTECTED]> wrote: > > In the query behind the report, you can go to the query properties > (right-click in the top area) and in Top Values, put 6. Be sure you > have it sorted appropriately so the first six are the ones you want. > > > > Tobi > > > > -----Original Message----- > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of kbuske1 > > Sent: Wednesday, July 13, 2005 11:43 AM > > To: AccessDevelopers@yahoogroups.com > > Subject: [AccessDevelopers] Limit Records in a Report > > > > > > I would like to limit the number of records shown in a report that > is > > generated from a bound form. There are 8 records in my table (that > is > > bound to my form) and I would like to show only the first 6 records > on > > my report. Is there a way to do this? Thank you! > > > > > > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! > > Groups Links > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links 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/
