English to Metric Update Query

[sonofroy]

Hi I have a table with this in it.

Feet Meters
1 456.324
2 102.456
3 233.167
4 678.090

I would like to create an update query that will automatically fill the
empty cells by using the conversion factor from feet to meters and vice
versa. Can someone lead me into the right direction here?

Thanks

 

[KARL DEWEY]

Back up your table first.
Query ----
Field Feet Meters
Update To [Meters]*Factor [Feet]*Factor
Criteria Is Null Is Null

Next time only store one and use factor in a query when you need the results
differently.

 

[John Spencer (MVP)]

One small quibble, make sure the IS Null criteria is on two separate lines.
Otherwise you won't change anything since the only records being chosen would be
those where BOTH Feet and Meters were blank.

Back up your table first.
Query ----
Field Feet Meters
Update To [Meters]*Factor [Feet]*Factor
Criteria Is Null Is Null

Next time only store one and use factor in a query when you need the results
differently.

Hi I have a table with this in it.

Feet Meters
1 456.324
2 102.456
3 233.167
4 678.090

I would like to create an update query that will automatically fill the
empty cells by using the conversion factor from feet to meters and vice
versa. Can someone lead me into the right direction here?

Thanks

 

[Gary Walter]

Even *smaller* quibble, I would think
you would want to use IIF in update:

Field Feet
Update To IIF([Feet] IS NOT NULL, [Feet], [Meters]*Factor)
Criteria Is Null

Field Meters
Update To IIF([Meters] IS NOT NULL, [Meters], [Feet]*Factor)
Criteria
Or Is Null

One small quibble, make sure the IS Null criteria is on two separate
lines.
Otherwise you won't change anything since the only records being chosen
would be
those where BOTH Feet and Meters were blank.

Back up your table first.
Query ----
Field Feet Meters
Update To [Meters]*Factor [Feet]*Factor
Criteria Is Null Is Null

Next time only store one and use factor in a query when you need the
results
differently.

Hi I have a table with this in it.

Feet Meters
1 456.324
2 102.456
3 233.167
4 678.090

I would like to create an update query that will automatically fill the
empty cells by using the conversion factor from feet to meters and vice
versa. Can someone lead me into the right direction here?

Thanks