I have a DB for a video collection, the DB containes a report that produces a complete list: [Position],[Number],
[Title],[No Discs]. My intention is that each record shows the number of small discs instead of a simple number. The problem is that if the first record for the first video has a total of 1 disc, all rest shows only one disc, regardless of the true amount.
If [Discos] = 1 Then
Disc1.Visible = True
Disc2.Visible = False
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 2 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 3 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = True
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
End If
End If
End If
While the above works on a form, it worthless on a report.
Does anyone have any ideas?
[Title],[No Discs]. My intention is that each record shows the number of small discs instead of a simple number. The problem is that if the first record for the first video has a total of 1 disc, all rest shows only one disc, regardless of the true amount.
If [Discos] = 1 Then
Disc1.Visible = True
Disc2.Visible = False
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 2 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 3 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = True
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
End If
End If
End If
While the above works on a form, it worthless on a report.
Does anyone have any ideas?