Convert Miles to Kilometeres

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
 
S

S.Clark

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

=Nz(txtMiles) * 1.6
 
S

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
Click to expand...

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