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

    Racing Qualifying

    I built a stock car racing database that I use a lot in the pits. I would like to add a qualifying form where I enter a car number, lap 1 time, lap 2 time, best time. could be up to 40 cars.
    Then have the form sort fastest to slowest time.
    I don't know if Access can do this or not. Anyone have any ideas?


    Or, I have a great one in Excel but I can't get any of the suggestions in the forum to work when I try to open Excel from an Access button.
    Thank you.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Certainly.

    If you want to limit each record to only 2 times, the best of the two can be a simple calculation. Base the form on a query that creates field with an expression,

    Best: IIf(time1<time2, time1, time2)

    Apply Descending sort parameter to this constructed field.

    Enter the lap time as a number in decimal minutes - 8.2, not text 8:12.

    After creating new record, will have to requery the form to refresh sort order.
    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.

  3. #3
    BEI77 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Location
    KY
    Posts
    24
    Ok, then how can I show the list of car numbers, listed from fastest to slowest on one sheet?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    You need a table structure first.

    I expect you need a table of cars and their info.

    Then you need a table for time records with fields for CarID, RecDate, LapTime1, LapTime2

    Then a form based on the described query for data entry of the time records. Use a combobox to offer a list of the cars to choose.

    Can build report to output the time data to printer.

    This is very basic Access functionality. Review http://www.rogersaccesslibrary.com/
    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.

  5. #5
    BEI77 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Location
    KY
    Posts
    24
    Got it! Works great Thank you.

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

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