Problem with expressions in a report.

B

Bullmann

I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")
 
O

Ofer

In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")
 
B

Bullmann

Ofer,
Thanks for the info, but it didn't work. That returned a 0 in the Program
Printer field on the report. I think maybe I wasn't clear about what I want
it to do. My intention is that the Program Printer field on the report is
blank if the Printed Program field is No.
Thanks for your help.
Bullman

Ofer said:
In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bullmann said:
I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")
Click to expand...
Click to expand...
 
O

Ofer

Did you try
=IIf(Nz([chkPrintedProgram],0)=True,"Yes.","")
In the control source o fthe Printer text field
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bullmann said:
Ofer,
Thanks for the info, but it didn't work. That returned a 0 in the Program
Printer field on the report. I think maybe I wasn't clear about what I want
it to do. My intention is that the Program Printer field on the report is
blank if the Printed Program field is No.
Thanks for your help.
Bullman

Ofer said:
In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bullmann said:
I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")
Click to expand...
Click to expand...
Click to expand...
 
B

Bullmann

I'm still not getting the desired result. It may be that I'm not
understanding your suggestions. I'm fairly new at this and I'm not all that
great with expressions. I do appreciate your help though.
Bullmann
 
Top