Marcelo Velasquez
May 18th, 2000, 08:44 AM
Hi
Can I make a filter in a recordset based on other recordset?
Example: I have a recordset (rs1) that has schedules Hr_ini, Hr_fim and other recordset (rs2) that contains schedules of blocked rooms, I want to select in the recordset (rs1) all free schedules, that is all schedules that don't contain in the other recordset (rs2).
How do I make this?
I am in advance grateful
Can I make a filter in a recordset based on other recordset?
Example: I have a recordset (rs1) that has schedules Hr_ini, Hr_fim and other recordset (rs2) that contains schedules of blocked rooms, I want to select in the recordset (rs1) all free schedules, that is all schedules that don't contain in the other recordset (rs2).
How do I make this?
I am in advance grateful