use of an iif stament in an update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i wish to update a table, but only with information that meets my criteria. I
wish to compare if a separate feild is within the limits, then update with a
calculation.

I wish to know what the proper syntax to do an update like this would look
like.

Please give an example if possible
Thanks!!
 
Hi,


UPDATE myTable
SET myField=myExpression
WHERE otherFIeld BETWEEN thisValue AND thatValue



You can do it in the query graphical designer. Change the query type from
its standard "SELECT" to an UPDATE query (through the menu or the toolbar).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top