Results 1 to 3 of 3
  1. #1
    alpha is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    4

    Smile Hide Rows in a Report

    Hi all,

    I am working on a report that has rows that need to be conditionally hidden. The data I'm working with is this.

    [Customer],[PymtDate],[PastDue],[CurrentBalance]

    I want to get the sum of all of the [CurrentBalance] records but I want to hide the rows from displaying in the report where [PymtDate] & [PastDue] are blank.

    Sample data:

    [Customer],[PymtDate],[PastDue],[CurrentBalance]
    Doe, John,6/1/2011,-1,1000.00
    Doe, John,1/1/2011,-1,2000.00
    Doe, John,,,500.00
    Doe, Jan,6/1/2011,-1,1000.00
    Doe, Jan,6/15/2011,-1,300.00

    Desired Output in Report:
    Doe, John -- $1,000.00
    Doe, John -- $2,000.00
    Doe, John -- Totals: $3,500.00

    Doe, Jan -- $1,000.00


    Doe, Jan -- $1,300.00
    Doe, Jan -- Totals: $2,300.00

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,129
    You would have to apply a condition to each control. This could be done with Conditional Formatting to return a Null if value in another control is Null. However, this would make the control appear not visible but it will still occupy space and result in blank row. VBA code can set the Visibility of the control, but again, think will result in blank row.

    Is the CurrentBalance a field in table or is it calculated from the records? If it is a field with static value and not dependent on the records for a calculation, filter the report to exclude records where the other data Is Null.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    alpha is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    4
    Thank you for the reply. I inserted a sub-report with the totals and then hid all of the records where 'PymtDate' IS NULL on the main report.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide Report on Textbox Value
    By alyon in forum Access
    Replies: 4
    Last Post: 07-29-2011, 11:19 AM
  2. Replies: 3
    Last Post: 09-15-2010, 01:04 PM
  3. Conditionally hide detail row in report
    By martinjamesward in forum Reports
    Replies: 5
    Last Post: 09-06-2010, 02:51 AM
  4. Hide zero value in report and date syntax
    By Alex Motilal in forum Access
    Replies: 0
    Last Post: 11-16-2008, 09:11 AM
  5. Replies: 1
    Last Post: 12-06-2006, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums