User Profile

Collapse

Profile Sidebar

Collapse
MikeT614
MikeT614
Last Activity: Sep 6 '13, 11:20 AM
Joined: Jun 20 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MikeT614
    replied to Creating a transit calculator ( Adding a number to a Date)
    in Access
    I was really hoping I could just create an equasion to calculate this through the control source... Is that not possible?

    I'm just not sure why the formula works like this

    Code:
    =DateAdd("n",600,#6/21/2013 3:00:00 PM#)
    But will not work like this..

    Code:
    =DateAdd("n",[Transit],[Current Time])
    See more | Go to post
    Last edited by zmbd; Jun 21 '13, 05:25 PM. Reason: [Z{Please use the [CODE/] formatting button to format your posted code and SQL}]

      Leave a comment:

    • MikeT614
      started a topic Creating a transit calculator ( Adding a number to a Date)
      in Access

      Creating a transit calculator ( Adding a number to a Date)

      I am trying to create a transit calculator as a tool for the database at my freight forward company.

      I have two fields that are manual entry

      Current time: 1500
      Miles Out 500

      These calculate our transit time:

      Transit (500/50mph)= 10hrs*60 = 600min

      What I am trying to do is take that transit time (in minutes) and add it to current time to give...
      See more | Go to post
      No activity results to display
      Show More
      Working...