Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sparkey75

    Sum an IIF statement in a expression

    Is it possible to have a sum of an IIF statement either in a Group footer or Report Footer. I have an IIF statement that works fine in the detail of a table, but require to sum the IIF statement. many thanks for any assistance that you maybe able to offer.
  2. sparkey75

    Using Mid in an expression

    I am trying to use Mid() in an expression: Mid(Fields!JOB.Value,4,3 <> "999") When I run the report, I get the following error: [rsRuntimeErrorInExpression] The Value expression for the textbox ‘Textbox1’ contains an error: Argument 'Length' must be greater or equal to zero. Any advice on...
  3. sparkey75

    IIF Statement in an Expression

    Many thanks that worked perfectly, you're a star! It is also possible to add another condition so that I can include the following, for example: I only want to show the results in the field if rate_no does not equal 9 or 999? Once again, many thanks.
  4. sparkey75

    IIF Statement in an Expression

    Is it possible to create an IIF statement in an expression in a field so that I can have the results back for the field depending on the IIF statement results? For example: IIF field1 is between "a" and "d" and "g" and "z" then field2 else 0 Many thanks for any assistance, as this would be...

Part and Inventory Search

Back
Top