Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Problem with expressions in a report.

Discussion in 'Information Technology' started by Bullmann, Oct 30, 2005.

  1. Bullmann

    Bullmann
    Expand Collapse
    Guest

    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.")
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    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" wrote:

    > 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.")
     
  4. Bullmann

    Bullmann
    Expand Collapse
    Guest

    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" wrote:

    > 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" wrote:
    >
    > > 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.")
     
  5. Ofer

    Ofer
    Expand Collapse
    Guest

    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" wrote:

    > 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" wrote:
    >
    > > 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" wrote:
    > >
    > > > 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.")
     
  6. Bullmann

    Bullmann
    Expand Collapse
    Guest

    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

    "Ofer" wrote:

    > 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
     

Share This Page