Results 1 to 2 of 2
  1. #1
    coliver is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2009
    Posts
    3

    Caculation of total time

    I still learning the program and need some help. I have created a table with four fields. The names are:1stBusOn, 1stBusOff, 2ndBusOn, 2ndBusOff.


    I want the time for the first two fields and the time for the second two fields to end up in a field called TotalRideTime. Also, if only one set of the fields are completed I still want that total time to in up in the the TotalRideTime field.
    I need some help please.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You should research Normalization and Table Design.

    Your table design is working against you.

    see these links:
    http://forums.aspfree.com/attachment...2&d=1201055452
    http://www.rogersaccesslibrary.com/T...lationship.zip

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

Similar Threads

  1. Replies: 42
    Last Post: 03-01-2013, 06:58 AM
  2. Replies: 8
    Last Post: 08-24-2012, 01:54 AM
  3. Total elapsed time
    By Craigind in forum Access
    Replies: 1
    Last Post: 05-14-2012, 03:54 AM
  4. Total Time box
    By imintrouble in forum Reports
    Replies: 3
    Last Post: 10-20-2011, 03:28 PM
  5. Need help with calculating Time total
    By Monoceros in forum Reports
    Replies: 1
    Last Post: 04-20-2009, 12:44 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