Multiple Criteria update

[jlg5454]

I have a problem that I having trouble resolving. I need field 1 to be updated based on multiple criterias. If field 2 is null set field 1 to off if field 1 = a hyphen '-' And if field 2 is not null set field 1 = to the value of field 2 that is not null. Is this possible?

Thanks,

Joe

 

[PHV]

Have a look at the IIf function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlg5454]

Thanks it did! Put in iif statement in the update query.