Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2001
    Location
    Edison, New Jersey, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expression error, but it looks good to me. (2K)

    I am using the following expression that worked OK last year, but is giving me an error that doesn't seem to make sense to me.

    The expression:
    Fees as Percent: Round((((IIf(IsNull([YSP Fee]),0,[YSP Fee])+IIf(IsNull([Disc Fee]),0,[Disc Fee])+IIf(IsNull([Orig Fee]),0,[Orig Fee])+IIf(IsNull([Broker Fee]),0,[Broker Fee]))/[Amount])*100),2)

    The error screen print is attached. The parens look balanced me. What do you think is really behind this error?

    TIA
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Expression error, but it looks good to me. (2K)

    Because of the AReport_Current.[ before and ] after the expression, I'd guess that you entered Areport_Current in the Table row by accident. Try clearing this.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Expression error, but it looks good to me. (2K)

    As an experiment, you might also try removing the " as Percent".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Star Lounger
    Join Date
    Jul 2001
    Location
    Edison, New Jersey, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expression error, but it looks good to me. (2K

    Thanks for the help. I was blindly changing queries to point to the new table and made the error pointed out by Hans.

    Thanks again to both of you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •