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
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
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