Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: calculating name fields in a report

    I need to divide the one field from the other and give a response of "OK" if the calc number is more than .80

    the fields are:

    [v100count] =Abs(Sum([v100status]="OK"))
    [countv100%] =Count([v100])

    I think my problem it the fields being generated by the expressions and I can't seem to figure out how to have this field get it's information after the other fields have been generated.

    Sorry if i'm not using the correct terms I am a newbie.

    thanks in advance.
    bob

  2. #2
    Join Date
    Sep 2003
    Posts
    19

    Re: calculating name fields in a report

    Set the controlsource of your result field to
    =iif(field1/field2 > .8,"OK","Not OK")

    Originally posted by bobhicky
    I need to divide the one field from the other and give a response of "OK" if the calc number is more than .80

    the fields are:

    [v100count] =Abs(Sum([v100status]="OK"))
    [countv100%] =Count([v100])

    I think my problem it the fields being generated by the expressions and I can't seem to figure out how to have this field get it's information after the other fields have been generated.

    Sorry if i'm not using the correct terms I am a newbie.

    thanks in advance.
    bob

Posting Permissions

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