Results 1 to 2 of 2

Thread: count of field

  1. #1
    Join Date
    Jul 2009
    Posts
    1

    count of field

    What I need help with is getting the diff. of two fields as a %.

    Here's what i have

    Equip. Desc.
    Work Orders
    Tasks

    For each Equip. Desc. there are multiple work orders, and task numbers.

    I need to get the count of work orders for each equip. and the count of tasks for each equip. Then get the percentage of work orders that are not tasks.

    Ex.
    Equip. = Falcon Wash
    Count of W.O. = 554
    Count of Tasks = 449
    which means that 18.95% of the total work orders for the Falcon Wash are not tasks.

    The fields now do not display the count of, but the ref number for each Work order and Task number.

    Any advice or help is greatly appreciated.

    I am certainly just starting out on this stuff, so if possible keep it simple for me.

    Thank You.

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    You can use COUNT in the SQL to do that. Are you using ASP-db or this is just a general SQL question?

    Frank

Posting Permissions

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