Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: Hie record in report if DCount greater than 0

    Hi,

    I have record listed in my report. These records come from a table in my database. For each record I have a hidden DCount function which counts the number of record in another table where the id equals the id in the report table.

    I would like for the record to be hidden if the DCount for a particular record is greater than 0. How can I best do this?

    Thanks in advance,
    geebee

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I would take a bit different approach and remove it from the report all together by limiting the datasource.

    SELECT yourField
    FROM yourTable
    WHERE dcount(stuff) = 0

Posting Permissions

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