View Full Version : IIF statements


manny2000
12-10-2003, 04:35 AM
I was wondering of anyone could help me please

I have a query which contains three different types of criteria with the Or functions, what I am trying to do is when it finds the field with the criteria ..... it should update all the data to a new field.

can anyone help????

manny2000

Rich
12-10-2003, 05:00 AM
Change the query to an Append query

Pat Hartman
12-11-2003, 11:40 AM
Don't you mean "update" query:)