Results 1 to 2 of 2

Thread: only first 10 [RESOLVED MYSELF => see second post for solution]

  1. #1

    Thread Starter
    Lively Member freightliner's Avatar
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    123

    only first 10 [RESOLVED MYSELF => see second post for solution]

    How can you make that the report only shows the top 10, for example, the top 10 amount files, show the 10 companies with the biggest open amount.
    Last edited by freightliner; May 13th, 2004 at 08:46 AM.
    very handy: [vbcode][/vbcode]
    VB.NET - VB6 - VBA - ASP - RPG(AS/400) - C++ - java - SQL

    look in the help, many probs can be solved that way.
    I know, i'm to lazy too.

    PLEASE PUT RESOLVED IF RESOLVED!!

  2. #2

    Thread Starter
    Lively Member freightliner's Avatar
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    123
    Solved it already, inserted a total field on amount, hide the field and insert a top N selection on the total
    very handy: [vbcode][/vbcode]
    VB.NET - VB6 - VBA - ASP - RPG(AS/400) - C++ - java - SQL

    look in the help, many probs can be solved that way.
    I know, i'm to lazy too.

    PLEASE PUT RESOLVED IF RESOLVED!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width