B
bw
My report has a "Control Source" as follow for a control on the report:
=IIf([Forms]![boxSeatsForMailings]![PrintWhich]=1,[PlatRev],IIf([Forms]![boxSeatsForMailings]![PrintWhich]=2,[TellRev],"Error"))
This works well, and allows me to choose which type of report to print.
When [PrintWhich]=2, I want to "ask" for a value of [TellRev], and then only
print for the value of [TellRev] that has been entered.
In the SQL statement for [TellRev] I have [Enter Teller Rev Num] for the
Criteria, and when executing the report, I get to enter the value of
[TellRev] I want to print, but the report "still" prints everything.
Values of [TellRev] can be like some of the following examples:
2.5.1
2.7.6
1.3.17
etc.
Can someone explain to me why I'm not able to restrict the report to the
values I want?
=IIf([Forms]![boxSeatsForMailings]![PrintWhich]=1,[PlatRev],IIf([Forms]![boxSeatsForMailings]![PrintWhich]=2,[TellRev],"Error"))
This works well, and allows me to choose which type of report to print.
When [PrintWhich]=2, I want to "ask" for a value of [TellRev], and then only
print for the value of [TellRev] that has been entered.
In the SQL statement for [TellRev] I have [Enter Teller Rev Num] for the
Criteria, and when executing the report, I get to enter the value of
[TellRev] I want to print, but the report "still" prints everything.
Values of [TellRev] can be like some of the following examples:
2.5.1
2.7.6
1.3.17
etc.
Can someone explain to me why I'm not able to restrict the report to the
values I want?