Results 1 to 6 of 6
  1. 12-17-2010, 08:41 AM #1
    Cran29
    Cran29 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    38

    How to calculate percentage of one field's value to another?


    I have two fields in a query and I wish to calculate the percentage value of one to the other. one field is [TotalHours] and the other is [ActiveHours] what would be the Expr to calculate the percentage of the active hours of worked hours
    Reply With Quote Reply With Quote
  2. 12-17-2010, 10:03 AM #2
    weekend00
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    isn't it "ActiveHours/TotalHours*100 " ?
    Reply With Quote Reply With Quote
  3. 12-17-2010, 10:26 AM #3
    Cran29
    Cran29 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    38
    Had a go but it only displays in the field what I have written.
    Reply With Quote Reply With Quote
  4. 12-17-2010, 10:54 AM #4
    weekend00
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    Quote Originally Posted by Cran29 View Post
    Had a go but it only displays in the field what I have written.
    didn't get you.
    Reply With Quote Reply With Quote
  5. 12-17-2010, 10:57 AM #5
    Cran29
    Cran29 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    38
    When I run the Expr it just displays the Expr as the answer
    Reply With Quote Reply With Quote
  6. 12-17-2010, 11:06 AM #6
    weekend00
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    add more fields which you like.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to calculate a percentage on form
    By jrockusa in forum Forms
    Replies: 1
    Last Post: 03-31-2010, 01:53 PM
  2. automatically having a field filled in based on another field's criteria
    By bjsbrown in forum Forms
    Replies: 4
    Last Post: 01-19-2010, 05:36 AM
  3. Creating field based an another field's total
    By yashysmashy in forum Queries
    Replies: 0
    Last Post: 09-02-2009, 03:48 AM
  4. Use report to Calculate sum and percentage
    By bangemd in forum Reports
    Replies: 3
    Last Post: 05-28-2009, 12:01 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums