Convert Miles to Kilometeres

  • Thread starter Thread starter Shazza
  • Start date Start date
S

Shazza

Hi

Is there a formula i can use that will automatically convert a number
entered into Kilometers in my Access tables

Ie someone has entered 3 miles and i need to know how many Kilometers it is
as i am not very good with convertions
 
There aren't calculated fields in Access Tables, but on a form, you can
calculate it at runtime.

=Nz(txtMiles) * 1.6
 
Hi

Is there a formula i can use that will automatically convert a number
entered into Kilometers in my Access tables

Ie someone has entered 3 miles and i need to know how many Kilometers it is
as i am not very good with convertions
Click to expand...

Try running an update query on the table, that will allow you to
convert the existing data in one hit
 
Back
Top