Recent content by rohiiit

  1. R

    Formatting NZ Function Value

    Hello guyz, IIf(IsNull([JCR - Act Lab_Crosstab Hr]![CP]),0,[JCR - Act Lab_Crosstab Hr]![CP]) I am trying to use the following expression. Problem is [CP] exists sometimes, but sometimes not in [JCR - Act Lab_Crosstab Hr]. How can I put an If statement in this expression so that even if cp...
  2. R

    IIF function as query criteria

    i used this fucntion but access styll says tht CP doesnt exist Nz([JCR - Act Lab_Crosstab Hr]![CP],0)
  3. R

    IIF function as query criteria

    thanks Rabbie, I am not sure how to put Nz command in the followin expression? Can you help please? IIf(IsNull([JCR - Act Lab_Crosstab Hr]![CP]),0,[JCR - Act Lab_Crosstab Hr]![CP]).
  4. R

    IIF function as query criteria

    IIF Function Problems Hello guyz, IIf(IsNull([JCR - Act Lab_Crosstab Hr]![CP]),0,[JCR - Act Lab_Crosstab Hr]![CP]) I am trying to use the following expression. Problem is [CP] exists sometimes, but sometimes not in [JCR - Act Lab_Crosstab Hr]. How can I put an If statement in this expression...
See more
Back
Top Bottom