Calculation - 12 Hour Time with NO am/pm in Microsoft Access


	Back to 12 Hour Time with NO am/pm Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Calculation

Giovanni Miranda

3 years ago

Good early morning!

I have 3 fields:

ATOD ' Arrival Time of Day that is "General Date"
DTOD ' Departure Time of Day that is also "General Date"
FLDuration ' Flight Duration

I want to calculate the time it takes to travel from one location to the other, ex. Los Angeles Int'l to Portland. I know the result will be in FLDuration, and the calculation:

FLDuration=[ATOD]-[DTOD]

Do I put this calculation in the Control Source of FLDuration? And how should the calculation be represented (=FLDuration=[ATOD]-[DTOD])?

Let me know if I'm on the right track and if not how should it be written and where.

	Kevin Robertson @Reply 3 years ago
In the Control Source of FLDuration: `=[ATOD]-[DTOD]` You don't need to specify the name of the field where the calculation is placed.

	Giovanni Miranda OP @Reply 3 years ago
Thanks, I appreciate your help again! Hey, by the way I've tried to add to your Tip Jar before but it won't get me past my email location...it's like on a loop! And keeps asking me to re-enter my email again...

This thread is now CLOSED. If you wish to comment, start a NEW discussion in 12 Hour Time with NO am/pm.

Next Unseen

New Feature: Comment Live View