use of an 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!!
 
D

Duane Hookom

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".
 
P

PC Datasheet

Duane,

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

Steve
PC Datasheet
 
D

Duane Hookom

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