Convert Miles to Kilometeres

[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

 

[Douglas J. Steele]

Multiply the miles by 1.6

 

[S.Clark]

There aren't calculated fields in Access Tables, but on a form, you can
calculate it at runtime.

=Nz(txtMiles) * 1.6

 

[Steve]

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

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

 

[Shazza]

Yey it works thank you very much