Results 1 to 4 of 4
  1. #1
    Shelley is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Location
    Massachusetts
    Posts
    9

    How do I write an expression for the following equation?

    =1-ActualMinutes/(AllowedMinutes*0.75)+100%



    ActualMinutes & AllowedMinutes are fields in a Table.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe something like this ...

    =(1-(ActualMinutes/(AllowedMinutes*0.75)))*2

    However, I would probably approach this with VBA and assign a couple of those equations to variables.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe you could provide data? 3 - 5 examples?
    ActualMinutes
    AllowedMinutes
    Expected results


    What does the 100% represent?

  4. #4
    Shelley is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Location
    Massachusetts
    Posts
    9
    The 100% is the standard quantity we are certain our employee can meet. We are pushing them to try to exceed it by 25% more.

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

Similar Threads

  1. Equation help
    By Thompyt in forum Programming
    Replies: 7
    Last Post: 05-15-2015, 05:31 PM
  2. Replies: 1
    Last Post: 07-02-2014, 09:27 AM
  3. Replies: 7
    Last Post: 07-02-2013, 12:02 PM
  4. Possible expression equation needed?
    By WayneSteenkamp in forum Access
    Replies: 6
    Last Post: 02-23-2012, 12:50 AM
  5. Write excel expression in access
    By ktmchugh in forum Queries
    Replies: 0
    Last Post: 07-01-2009, 02:47 PM

Tags for this Thread

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