Update Query claculation

  • Thread starter Thread starter MyMel
  • Start date Start date
M

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
 
What does not work for the update query? Wrong conversion? No conversion?
Post the SQL of both queries.
 
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
Click to expand...

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.
 
Back
Top