Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: display a certain number in report

    Hi,
    I am trying to list only 3 items, top 3, from a subfrom in a report. This subform may have 16 items and when I put this in the details section of the report I get the entire listing, which i don't want.

    thanks

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by Leventcos21
    Hi,
    I am trying to list only 3 items, top 3, from a subfrom in a report. This subform may have 16 items and when I put this in the details section of the report I get the entire listing, which i don't want.

    thanks
    Hi Leventcos21

    Give this a try. If your Report is based on a Query, in the QBE window select the Field that you want the Top 3 results from. Then on the ToolBar look next to the Totals button and find the Top Values button. Click on that ComboBox or just Type directly in it what number you want, then run your Query. It will give you the result and then goes to your Report. If you want to change that on the fly from Form level someone else might have to give you help on that way.

    just trying to lend a hand.
    have a nice one,
    BUD

Posting Permissions

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