Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: Datediff HELP!!!

    I have a form that has a start time end time and total time. I am using date diff to calculate the total time and it is working fine, but i want the output to be placed into Total time field of a table. I am new to access and DB in general. Any help would be appriciated.

    A copyof the databse can also be found at http://briefcase.yahoo.com/gregorycolucci

    un: gregorycolucci
    pwd: escort

    The form is post op update and the table is scheudling
    Greg

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    DateDiff("d", yourTextBoxWithStartDate, yourTextBoxWithEndDate)
    will compute the date difference in days

    Just have a look to DateDiff help

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by gregcolucci
    I have a form that has a start time end time and total time. I am using date diff to calculate the total time and it is working fine, but i want the output to be placed into Total time field of a table. I am new to access and DB in general. Any help would be appriciated.

    A copyof the databse can also be found at http://briefcase.yahoo.com/gregorycolucci

    un: gregorycolucci
    pwd: escort

    The form is post op update and the table is scheudling
    Greg
    Hi Greg and Welcome to the forum. Being as you are new to Access and DB in general I would like to make one small point. So far you've done well being as you have already made the DateDiff work. But, storing that value in a table is not a great thing. You should once calculated keep it at form level. As I have been told that is the logical and best way to store calculated values, however, as with anything else there are exceptions. You may have your reason but I just wanted to point that out to you firsthand so as to avoid any future problems. There are many posts on here about storing values/calculations. Hope this proves to be something good for you and have a nice time here. A good place to be.

    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •