iif statmtent in an update query

M

mary

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!!
 
Top