Updating A Field In A Query

[Mattster2020]

Afternoon All,

I have a query that I want to update the value of a field if another field is a certain value; for instance:

If Holiday_Full_Day = -1
Then Holiday_Hours = 432

Would I be able to use an update query to perform this action?

Regards,

Mattster

[CreganTur]

Using an update query will update all accounts that match your criteria. If you're okay with that, then an update query would work. It just depends on what you want to do.