Results 1 to 7 of 7
  1. #1
    Smithy1792 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2022
    Posts
    2

    Percentage Queries

    Hi,



    I have just started learning Access and have come across a few obstacles that I cant find a solution on Youtube or online.

    I have to 2 columns labelled charges before and charges after (using percentages) and a third which automatically populates the difference - or +.

    I am now trying to create a query which shows what percentage of all the data have moved to a higher charging structure but cant figure out how to show this as a percentage.

    Thanks for the help in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make Q1 to sum the totals.
    make Q2 to use your table & Q1 , to calc the %.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Wouldn't that be anything where the third column is > zero?
    As you are working with %, wouldn't that be the value?
    IE was 10% now 15%, difference is 5 (%)
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    perhaps help if you showed some example data and the calculations you are actually using. It may be you are using the format function which converts a numeric value to a string - and strings behave differently to numbers

  5. #5
    Smithy1792 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2022
    Posts
    2
    So I have got showing the difference in charges as shown below:

    I just need to show how much of all the plans have increased charges.

    Hope this helps,

    Thank you.
    Attached Files Attached Files

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    So column 3 > 0 ??
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Based on the data, the desired result is 25% ? I guess you could do as per post 2, or try (Dcount of records where change > 0) divided by DCount of records.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-31-2021, 04:29 PM
  2. percentage in crosstab queries
    By sk88 in forum Queries
    Replies: 3
    Last Post: 03-09-2015, 02:55 PM
  3. Percentage
    By azhar2006 in forum Queries
    Replies: 3
    Last Post: 11-15-2014, 02:22 PM
  4. Replies: 3
    Last Post: 12-01-2010, 12:30 PM
  5. Percentage Queries
    By bangemd in forum Queries
    Replies: 18
    Last Post: 05-21-2009, 09:32 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