use of an iif statmtent 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!!
 
It would help if you provided some actual table and field names with your
exact logic. You can either add a criteria to the query to ignore some
records or use the IIf() function in the "update to".
 
Duane,

I made the same request in her earliest post and she responded back with
details to which I then responded.

Steve
PC Datasheet
 
I noticed after replying. Kinda like taking a test back in school where they
suggested you read through all the unanswered questions first ;-)
 
Back
Top