Hi there

[cristine]

I am very happy to have found this forum as I believe there would an answer to any question posted.

I am comfortable with Excel,but I know that Access can be very useful. I need to the skills slowly.

I have made some progress when I was doing my company's travel logs (they run a transport service) and from there I managed to learn quite a number of things on my own, trial and error

I just tried out Access 2010 and its great as I was able to do some calculations which I could not earlier versions( ignorant I guess).

What I need to know is that , is it possible to calculate the speed of a vehicle in Access. When I tried, it return quite a gigantic number. I figure that when I used 10km / 0:20 , it didnt quite understand.

So my question is if I was able to convert 0:20 to a number then it would return the right answer. Ex (10km X 60min) divided by 20minutes will return 30km/hr.

Please help.

 

[Rabbie]

You need to understand how time is stored in Access. It is stored as a fraction of a day. so 12 hours is stored as 0.5. This means that your formula needs to have the time adjusted to work properly. Try using the Minute function to return the minutes in a time field.

 

[cristine]

Good morning Rabbie,

Thank you for your kind reply. Yes I will try your suggestion.

Have a nice day