Results 1 to 4 of 4
  1. #1
    delmaruser is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2

    Calculate percentages in query

    I have a query where I show the following results:
    Cash-Out Refinance 100.00
    NoCash-Out Refinance 50.00
    Purchase 50.00
    200.00

    What I would like to do is add an extra column to show the percentages as seen below:




    Cash-Out Refinance 100.00 0.5
    NoCash-Out Refinance 50.00 0.25
    Purchase 50.00 0.25
    200.00 1

    What is the easiest way of doing this?

    Thank you,

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here's a tutorial on how to do this:

    http://www.datapigtechnologies.com/f...centtotal.html

  3. #3
    delmaruser is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2
    Thank you for providing the link to the video this is exactly what I was looking for.

  4. #4
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Glad to have been helpful.

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

Similar Threads

  1. How do I query and add percentages?
    By lccrews in forum Queries
    Replies: 3
    Last Post: 08-21-2017, 02:22 PM
  2. Calculate percentages within a query
    By AccessNovice16 in forum Queries
    Replies: 2
    Last Post: 09-28-2016, 12:21 PM
  3. Percentages Query
    By mabrown81 in forum Queries
    Replies: 12
    Last Post: 11-01-2012, 12:50 PM
  4. Replies: 7
    Last Post: 05-06-2012, 12:20 PM
  5. Replies: 1
    Last Post: 03-04-2012, 11:22 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