Results 1 to 2 of 2
  1. #1
    mdnikki is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2012
    Posts
    63

    How to get a percentage of two fields in a query


    I am trying to calculate how successful some of our appeals were but looking at the number of solicitations versus the number of responses and can't seem to figure out how to do the percentage. I would want to use the Count of Appeal (which is the number of solicitations we sent out) against the count of gift amount which is the number of responses. And possibly also see the average gift amount of each of the appeals as well. Any help is appreciated.

    Appeal Description SumOfGift Amount CountOfGift Amount Count of Appeal
    12AAA 1stMail $2,483,799.03 10821 26231
    12AAA 1stMail - New Adds $5,150.00 40 6252
    12AAA 1stMail Sybunt $121,463.24 828 18060
    12AAA 2ndMail $313,444.00 1734 20796
    12AAA 3rdMail $16,691.33 160 20722
    12AAA DirectSolicitation $960,012.74 233
    12AAA In House Phone $1,200.00 1
    12AAA InPew $3,030,022.69 15619
    12AAA Internet $186,370.05 433
    12AAA Matching Gifts $35.00 1
    12AAA Payroll $20,606.14 35
    12AAA Phone $209,414.00 1268

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    count([gift amount])/count([appeal]

    Average gift amount

    sum([gift amount])/count([gift amount])

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

Similar Threads

  1. Query to perform percentage
    By mari_hitz in forum Queries
    Replies: 4
    Last Post: 04-10-2012, 10:56 AM
  2. Grouping query with percentage
    By msadiqrajani in forum Queries
    Replies: 1
    Last Post: 03-16-2012, 02:14 PM
  3. Add fields and find percentage
    By gurp99 in forum Queries
    Replies: 1
    Last Post: 08-09-2010, 03:57 PM
  4. Percentage Calculation in a Query
    By Lynn in forum Queries
    Replies: 1
    Last Post: 07-16-2010, 11:23 PM
  5. percentage in a query
    By Peljo in forum Access
    Replies: 2
    Last Post: 02-27-2008, 10:51 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