Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    3

    I need to return a value for calculation.

    I have a form that I want to use for a scorecard situation. The employee can get a number for a compatency that we are asking for. The number will fall within a range, say 100-90 will equal 5, 89-80 will equal 4, 79-70 will equal 3, 69-60 will equal 2 and 50 and below will equal 1. I am not hung up on the equal number, but I need for the users of the form to be able to type in a number, 75, and I need for the correct number to go toward a grand total number that is also on the form. I have a total of six of the competencies that I need to set this range thing up for. Can this be done? Thanks for reading and helping!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Can you create a function that will return the correct value with the user input? It looks like a good place for a Select Case structure.

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

Similar Threads

  1. Calculation Help
    By edge5511 in forum Programming
    Replies: 4
    Last Post: 12-18-2015, 11:11 AM
  2. Date Calculation -- HELP!
    By klaauser in forum Forms
    Replies: 0
    Last Post: 12-22-2008, 02:14 PM
  3. Calculation is off by a few cents...
    By Jule in forum Reports
    Replies: 3
    Last Post: 05-01-2006, 01:06 PM
  4. Calculation
    By thestclair in forum Reports
    Replies: 1
    Last Post: 04-29-2006, 11:03 AM
  5. Report Calculation
    By thestclair in forum Reports
    Replies: 2
    Last Post: 03-28-2006, 12:23 PM

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