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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use of an iif statmtent in an update query 3
iif statment in update query 4
IIF Query Help needed 1
IIF update query with Between Criteria 5
Creating an update query that uses multiple parameters 2
Date comparison in IIF statement in a query 1
Using IIF in UPDATE 4
Pass-Through query used to update an access table 2

Back
Top