Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Unanswered: Finding Check Box %

    Hi
    I am a very basic Access user, and need a bit of assistance trying to find the % of info contained in check boxes.
    As part of a quote register I have one field that is for quotes Won, how do I find an % of quotes won using this info.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    At the basic level, Total of Records with Quotes Won ÷ Total of Records * 100.

    Do you want to do this automatically or as a once off?

    What is the name of the table?
    What is the name of the field?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jul 2008
    Posts
    5
    Thanks StarTrekker

    Table Name is Quote Register
    Field Name is Quote Won

    Dave

  4. #4
    Join Date
    Jul 2008
    Posts
    5
    StarTrekker

    Would be good if this was Automatic

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well this will just give you the answer:

    SELECT Sum(Abs([Quote Won]))/Sum(1)*100 AS PercentageWon FROM [Quote Register];

    It's up to you to integrate that into whatever you have
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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