Results 1 to 2 of 2
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    Help with AVG function


    I have a report abending today. The report field causing the abend is
    "Avg(LF2FP2)"

    I think the problem is a zero value in the field LF2FP2.

    Attached is a screen print of the error. I know it is this field because I can remove it and the report works fine.

    Does anyone have a suggestion for a simple fix?

    Thank you
    Russ
    Rneuman @ scaninc.org

  2. #2
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    More info - Query is feeding a bad field #error

    the old divide by zero pbl was the root cause

    I put this code in for a fix:
    LifeTot2: IIf([LifeTot]>0,[LifeTot],1)

    It seems to be good, so far.
    Russ

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Function Help
    By th3spankst3r in forum Programming
    Replies: 12
    Last Post: 03-22-2010, 12:41 PM
  2. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM
  3. Sum Function Help
    By newbie in forum Reports
    Replies: 3
    Last Post: 06-30-2009, 05:32 PM
  4. function key
    By marianne in forum Access
    Replies: 5
    Last Post: 05-14-2009, 01:26 AM
  5. Is there a function to do this....
    By Nowherefast in forum Access
    Replies: 2
    Last Post: 12-31-2008, 08:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums