Create first a simple select query:
Select iif(hotelname="santa marina p" and instr("/dv1/drs/", "/" & roomtype & "/")<>0,"santa marina b", hotelname) as hotel, 7d_adults, 7d_inf, 14d_adults, 14d_inf from passengers500;
Save the query.
Create a TOTAL query against the above query