Results 1 to 2 of 2
  1. #1
    BEI77 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Location
    KY
    Posts
    24

    Race car scaling (complicated)


    A race car has 1 spring for each wheel. The weight value for that spring is calculated by how much weight it takes to compress the spring 1" ie. a 250lb spring. Each spring has a jack bolt, which is a way to adjust the compression on that spring. Each jack bolt has 16 threads per inch. Let's assume I have on the Left Front wheel a 250 lbs spring Left Rear is a 150 lb spring RF is a 250 lbs spring and the RR is a 300 lbs spring. Let's say the LF Wheel Weight is 730 RF is 645 LR is 865 RR is 515. The question the formula needs to answer is, if I turn the jack bolt on 1 spring, 1 turn, what does that change each wheel weight to? IS THERE A WAY TO DO THIS IN ACCESS?
    Thank you for all help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I don't know the formula. However, a dynamic variable can be incorporated in any formula. The variable can be a parameter that uses popup input prompt or can reference a control on form or report.

    Expressions can be constructed in query or in textbox or in code (macro or VBA).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Scaling a Chart Axis
    By Paul H in forum Reports
    Replies: 5
    Last Post: 10-16-2013, 01:50 PM
  2. Report Width - Scaling dynamically
    By RonL in forum Reports
    Replies: 5
    Last Post: 06-30-2013, 07:44 PM
  3. Handicap Race System.
    By Mantaii in forum Reports
    Replies: 4
    Last Post: 01-16-2012, 07:56 AM
  4. Calculating race finishing positions
    By Coheeba in forum Queries
    Replies: 4
    Last Post: 09-01-2011, 12:44 PM
  5. Race Sports Time format
    By flebber in forum Database Design
    Replies: 0
    Last Post: 09-13-2009, 08:38 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