Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

hi

Discussion in 'Information Technology' started by Asma Shah, Jul 28, 2006.

  1. Asma Shah

    Asma Shah
    Expand Collapse
    Guest

    I have starting time and hours and an empty field known as FINISHING TIME ?
    what should i do to get Finishing time?
     
  2. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    You need to ensure that both field are fomated as time fields and then simply
    add then together. Unless you REALLY need to store the information it's best
    NOT o store them but simply display the data on a form or within a report

    [StartTime] + [HoursTime]

    By placing text within [ ] this denote that these are field names so you
    will need to change them to the names in your table.


    Hope this helps



    "Asma Shah" wrote:

    > I have starting time and hours and an empty field known as FINISHING TIME ?
    > what should i do to get Finishing time?
    >
     
  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 11 May 2006 20:24:54 GMT, "Asma Shah" <u21773@uwe> wrote:

    >I have starting time and hours and an empty field known as FINISHING TIME ?
    >what should i do to get Finishing time?


    It's best to use Date/Time fields ONLY for specific points in time;
    durations should be stored as a Number, preferably a long integer in
    the finest time resolution needed (hours, minutes, or seconds).

    If you have a starting time, a finishing time, and a duration, you
    should store *only two* of these in your Table; the third can be
    calculated on the fly.

    Assuming that time to the closest hour is adequate, you can use a
    calculated field in a Query:

    Finishing Time: DateAdd("h", [Hours], [Starting Time])

    If [Starting Time] contains #5/11/2006 8:30am# and [Hours] contains 9,
    then [Finishing Time] will come out to #5/11/2006 5:30pm#.

    John W. Vinson[MVP]
     

Share This Page