Update Query claculation

[MyMel]

I am trying to update a field with the dividen of to other fields
Field to be updated : USD
Update to: [Pesos]/[ExchangeRate]

If I do a select query it works but not with an update query. Suggestions
greately appreciated.

Melody

 

[KARL DEWEY]

What does not work for the update query? Wrong conversion? No conversion?
Post the SQL of both queries.

 

[John W. Vinson]

I am trying to update a field with the dividen of to other fields
Field to be updated : USD
Update to: [Pesos]/[ExchangeRate]

If I do a select query it works but not with an update query. Suggestions
greately appreciated.

Melody

Correct the error in the update query.

If you would like help doing so please post the SQL view of the query so we
can see what you're doing, indicate what "doesn't work", and perhaps post a
few rows of sample data.