update one field using criteria from multiple fields

[sfgiantsdude]

I am designing an update query for a specific field in my table

There are 3 fields: PROVIDER_GROUP, MEDI_CAL_IND, MEMBER_LOW_CAT

I want to update the value of "Y" in the MEDI_CAL_IND field to "N" if:

the medi_cal_ind value is "Y" AND the PROVIDER_GROUP is "Medicare_Part_D"

OR

the medi-cal_ind value is "Y" AND the MEMBER_LOW_CAT is "Commercial"

A screenshot of the table is attached.

Thanks!

[June7]

Is Medi_Cal a text or Yes/No field type

If Yes/No Try:

UPDATE Extract Set Medi_cal = False WHERE Medi_cal=True AND (Provider_Group = "Medicare_Part_D" OR Member_Low_Cat="Commercial")

[sfgiantsdude]

thanks for responding. It is actually just a text field however. Is the above syntax something i could use in design view or is it vba code?

thanks!

[June7]

You could copy/paste that into SQL View of query designer then view the setup in Design View.

Change the True and False to "Y" and "N"

[sfgiantsdude]

Thank you.

Is there any way to do this without having to change it to a Yes/No field. I am not familiar with this data type. The data source isn't set up to accomodate the Yes/No format I don't believe.

[June7]

I did not suggest you change the field type.

I said change the criteria in the UPDATE sql statement to use "Y" and "N" instead of True and False.