Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Joliette, Quebec, Canada
    Thanked 0 Times in 0 Posts

    A query quandry in calculation rates (2000)

    In a query, I use the rate function to compute that rate of change of industrial accident by industrial sector. The query has the industrial sector ant the accident number for that sector between the 1998, and 2003. The expression is rate change:=rate(5;0;[1998];[2003];0) For usual rates the query works find, but if there an exceptional high change as in the case where 1998 = 3 and 2003=470. a computational error is generated. I tried testing the performance of this rate fuction with Excel. Using the same parameters., the highest value that I could get a computation was around 450. This error causes the report attached to this query to crash. Therefore, what can I do to get around an incalculable rate?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: A query quandry in calculation rates (2000)

    See my reply to <post:=571,790>post 571,790</post:>: try supplying a guess, e.g. 200%.

Posting Permissions

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