<div>
I don't know what is the purpose of this database, but you can calculate the time based on average travel speed.<br />
<br />
e.g if travel speed is 20kmph then 40km = 2hrs travel time.
</div>


I don't know what is the purpose of this database, but you can calculate the time based on average travel speed.

e.g if travel speed is 20kmph then 40km = 2hrs travel time.

<div>
The purpose it to calculate total shift times including travel to and from site. Do you know of a way to write that into a query?
</div>


The purpose it to calculate total shift times including travel to and from site. Do you know of a way to write that into a query?

<div>
You could create a VBA function in Access to calculate Trip time <br />
<br />
e.g. CalculateTripTIme(Distance<wbr />Travelled,<wbr />AvgSpeed)<br />
<br />
and make call to that function in query<br />
<br />
e.g. Select CalculateTripTime(Distance<wbr />Travelled,<wbr />AvgSpeed)<br />
<br />
where DistanceTravelled and AvgSpeed can be Table Fields.
</div>


You could create a VBA function in Access to calculate Trip time

e.g. CalculateTripTIme(DistanceTravelled,AvgSpeed)

and make call to that function in query

e.g. Select CalculateTripTime(DistanceTravelled,AvgSpeed)

where DistanceTravelled and AvgSpeed can be Table Fields.

<div>
Thankyou for explaining after reading you advise it all makes sence now...great advise!
</div>


Thankyou for explaining after reading you advise it all makes sence now...great advise!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have created a MS Access database which calculates the distance from one point to another. The result is given in Kilometers and Nautical Miles. Now what I need to do now is to calculate the time duration of the trip. <br />
<br />
I know I can use the result of the kilometers to calculate the travel time, I just can't think of how and what would be the best way. At the moment I don't have the database recording the results of the distance calculations.<br />
<br />
Any suggestions?<br />
<br />
Cheers<br />
SS
</div>
</div>


Hi,

I have created a MS Access database which calculates the distance from one point to another. The result is given in Kilometers and Nautical Miles. Now what I need to do now is to calculate the time duration of the trip. 

I know I can use the result of the kilometers to calculate the travel time, I just can't think of how and what would be the best way. At the moment I don't have the database recording the results of the distance calculations.

Any suggestions?

Cheers
SS

Trip Duration

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.