Query problem (1 Viewer)
- Thread starter kmaz79
- Start date
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 02:38
- Joined
- May 7, 2009
- Messages
- 19,231
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
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
Sorry but it doesn't seem to work
i should get clear that the final table has been the result of consecutive queries coming from the first table "PASSENGERS500", (number of 7days-adult passengers, number of 7 day-infant passengers and so on..) and ending with the final result with a composing query of all the above ...
i just want to add an exception for the case of "Santa Marina P" and "Santa Marina B"...
i should get clear that the final table has been the result of consecutive queries coming from the first table "PASSENGERS500", (number of 7days-adult passengers, number of 7 day-infant passengers and so on..) and ending with the final result with a composing query of all the above ...
i just want to add an exception for the case of "Santa Marina P" and "Santa Marina B"...