Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2006

    Unanswered: Insert Date Not Working

    I have the attached database (Access 2007) and am trying to do two things...

    1. When the user double-clicks on "Date Closed" on the frmNewWorkOrder, it opens the form, CalPopUp, and the user can select the date that the work order is closed. This date is then entered into the "Date_Closed" field.

    2. The field "Time_Spent" needs to automatically say the amount of time that was spent on the work order. This should be accomplished by finding the difference from the "Date_Occurred" field and the "Date_Closed" fields and place this in the "Time_Spent" field.

    Can anyone help me out?

    Thanks in advance,

    Attached Files Attached Files

Posting Permissions

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