Update column in query based on value in the same query?

[FoolzRailer]

Hello

I'm trying to fill the column Saneres/Vurderes.



Basically what I need it to do, is that if any of the black marked ones are true in TVObsKode, TVObsKlasse, Type1, Type 2 (ex. "AF>=3 until "RØ">4), it needs to put in a "Saneres" if any of the white ones are true, it should say "Vurderes". I should say, that the column being updated, is created by the query, so it is not an existing table.




Any help on doing this, or how I should go about it.

[orange]

What are you trying to accomplish in plain, simple English? We need some business context to understand WHAT before we can offer options for HOW.

[FoolzRailer]

What is shown in the criteria, is observations in pipes, their severity and types. Based on this, they either must be fixed (saneres), or just evaluated (vurderes).
So all those criteria marked with black, shows observations which must be fixed, example is RØ 4 (last black), which are roots in the pipes.

This way, when I later export it to excel, they can see which group the observations belong to.

[Bulzie]

Sounds like you need an IIF statement, something like:

Saneres_Vurderes: IIF([TvOBSKode] = "AF" and [TvOBSKlasse]> 3.5, "Fix", "Evaluate")

You can look up IIF statements online but basically its IIF([Expression],If True,If False) and you can have multiple inside each other

Saneres_Vurderes: IIF([TvOBSKode] = "AF" and [TvOBSKlasse]> 3.5, "Fix", IIF([TvOBSKode] = "F5" and [TvOBSKlasse]> 4, "Fix", "Evaluate"), "Evaluate"))

[davegri]

Check out Update queries. They have an 'Update to' row.
BTW Saneres/Vurderes is a terrible data name. It could be interpreted by Access as "Santeres divided by Vurderes".