Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Microsoft Access Date & Time Calculations

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
30,996
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 3, 2008

How to calculate the number of hours or days between two dates in Microsoft Access

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 3 dislikes

Link to this comment:

Share to:
see all

All Comments (10)

Sign In or Sign Up now to post a comment!
  • thnx so much!

  • I got a task and see if you can accomblish this. I couldn't accomblish cause it's not like excel.

    A column = ID, B column = Name, C column = Donate, D column = Date, E column = Total (date). Task: Pretend that there's 5 record. All record donated as 5, 10, 15, 20, 25. Date are 9/1/11 (3 rows down) and 9/2/11 (2 rows down). On Column E; try to code so that it calculate row C only if row D = 9/1/11.

  • Hello Richard I was making a database about the audio files with their audio lengths in the column. I want to know can we have a query that would calculate the total length of audio files I have in Hours:Minutes:Second format for that particular CD or Album

  • Very Clear and to the point lesson. Thanks.

  • thank you for this. very helpful!

  • IF ITS 9:30PM EASTERN IN THE US WHAT TIME IS IT IN THE UK?

  • Thank you!

  • Great Job, Thanks for the tip. How can you do this from mon to friday without doing each day at a time?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more