Tell me how you can change the record through the request like this: "male" to "male", "female" to "female" in one request. I tried to put the first value in the selection condition, and in the Update second line, but it does not work + you can only change 1 value in the query, but you need both male and female.

    1 answer 1

    UPDATE [Ρ‚Π°Π±Π»ΠΈΡ†Π°] SET [ΠΏΠΎΠ»Π΅] = IIF([ΠΏΠΎΠ»Π΅]="муТской","ΠΌΡƒΠΆΡ‡ΠΈΠ½Π°","ΠΆΠ΅Π½Ρ‰ΠΈΠ½Π°") WHERE [ΠΏΠΎΠ»Π΅] = "муТской" OR [ΠΏΠΎΠ»Π΅] = "ТСнский"

    In the query builder:

    1. Add a table at the top
    2. Set request type - Update
    3. Fill from top to bottom at the bottom in one column:
      • Field: field name
      • Table Name: Table Name
      • Update: IIf ([table]! [Field] = "male"; "male"; "female")
      • Selection condition: "male"
      • or: "female"