Results 1 to 2 of 2
  1. #1
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89

    Reports

    I have 2 tables on one report, 1 is visible, the other visible = no, Is there a way to make that visible = yes when you reach a certian count (60days)

    thanks


    -novice

  2. #2
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    Use an If...Then statement.

    Code:
    IF [yourcountfield] >= 60 Then
    
    Me.Table1.Visible = False
    Me.Table2.Visible = True
    
    Else
    
    Me.Table1.Visible = True
    Me.Table2.Visible = False
    
    End IF

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

Similar Threads

  1. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  2. Get all reports
    By nkuebelbeck in forum Programming
    Replies: 13
    Last Post: 06-27-2011, 12:30 PM
  3. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  4. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 PM
  5. Reports ??? Help!
    By Vikki in forum Access
    Replies: 3
    Last Post: 02-08-2010, 09:52 AM

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