Calculating speed

[RC]

I have a form on which I want to create a text box with a formula for
calculating speed in Yds per Min.
Just to test things out, I have already created text boxes in my form with
formulas to convert miles to yds - =[Distance in Miles]*1760 - and calculate
start/stop time in mins - =(DateDiff("n",[Release Time],[1st Bird Time])).

So both of these return the values I want. (yards and minutes respectively)

Now - how can I create a formula using the formulae above to give me a text
box value which calculates yds/min

By the way - you guys do a brilliant job in answering all of these questions
so thanks for that. Wouldn't know where to go without you all.

 

[Allen Browne]

=[Distance in Miles] * 1760 / DateDiff("n", [Release Time], [1st Bird Time])

 

[RC]

Great - That works just fine.
Now - the answer comes back to 12 decimal places. How do I change it to 2
places. I have tried changing the text box format to 'general number' and 2
decimal places, but it makes no difference.

Thanks

=[Distance in Miles] * 1760 / DateDiff("n", [Release Time], [1st Bird Time])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form on which I want to create a text box with a formula for
calculating speed in Yds per Min.
Just to test things out, I have already created text boxes in my form with
formulas to convert miles to yds - =[Distance in Miles]*1760 - and
calculate
start/stop time in mins - =(DateDiff("n",[Release Time],[1st Bird Time])).

So both of these return the values I want. (yards and minutes
respectively)

Now - how can I create a formula using the formulae above to give me a
text
box value which calculates yds/min

By the way - you guys do a brilliant job in answering all of these
questions
so thanks for that. Wouldn't know where to go without you all.

 

[Allen Browne]

Try Fixed, and 2 decimal places.

I think that would be better than:
=Round([Distance in Miles] * 1760 / DateDiff("n", [Release Time], [1st Bird
Time]),2)

BTW, you can divide one text box by another in your form, e.g.:
=[txtDistance] / [txtMinutes]

And sometimes you need to typecast the result of the calcuation so Access
understands the intended data type. Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Great - That works just fine.
Now - the answer comes back to 12 decimal places. How do I change it to 2
places. I have tried changing the text box format to 'general number' and
2
decimal places, but it makes no difference.

Thanks

=[Distance in Miles] * 1760 / DateDiff("n", [Release Time], [1st Bird
Time])

I have a form on which I want to create a text box with a formula for
calculating speed in Yds per Min.
Just to test things out, I have already created text boxes in my form
with
formulas to convert miles to yds - =[Distance in Miles]*1760 - and
calculate
start/stop time in mins - =(DateDiff("n",[Release Time],[1st Bird
Time])).

So both of these return the values I want. (yards and minutes
respectively)

Now - how can I create a formula using the formulae above to give me a
text
box value which calculates yds/min

By the way - you guys do a brilliant job in answering all of these
questions
so thanks for that. Wouldn't know where to go without you all.