can an update query do different values

[sparks]

I was updating a field based on the values in another field.
this is simple but then I thought of something different.

can you say update fieldname1 to a 1 if fieldname5 has a 1 else
update fieldname1 to a 0.

I don't think this can be done but I wanted to ask.

Jerry

[fredg]

On Tue, 11 Oct 2005 15:58:51 GMT, sparks wrote:

I was updating a field based on the values in another field.
this is simple but then I thought of something different.

can you say update fieldname1 to a 1 if fieldname5 has a 1 else
update fieldname1 to a 0.

I don't think this can be done but I wanted to ask.

Jerry

Sure, why not.

Update YourTable Set YourTable.[Field1] = IIf(YourTable.[Field5] =
1,1,0)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[sparks]

Worked like a champ I just dropped the where clause.
was not sure if an update query would work without a where clause but
I learned something new

thanks for your help

Jerry
On Tue, 11 Oct 2005 09:05:35 -0700, fredg <fg******@example.invalid>
wrote: