SELECT DISTINCT orariatbl.orarioID, orariatbl.Orario
FROM orariatbl, eidiyphresiontbl
GROUP BY orariatbl.orarioID, orariatbl.Orario, eidiyphresiontbl.haraktirismosypiresiasID, eidiyphresiontbl.eidosypiresiasID
HAVING (((orariatbl.orarioID) In (1,2,3,6,8)) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=1) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias] And (eidiyphresiontbl.eidosypiresiasID) Not In (58,59,60,19))) OR (((orariatbl.orarioID) Not In (5,9,10,11,12,13,14,15,16,17,18,21,22)) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=2) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias] And (eidiyphresiontbl.eidosypiresiasID)=18)) OR (((orariatbl.orarioID) Not In (1,2,3,5,6,8,19,20)) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=2) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias] And (eidiyphresiontbl.eidosypiresiasID)=17)) OR (((orariatbl.orarioID) Not In (1,2,3,5,20)) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=2) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias] And (eidiyphresiontbl.eidosypiresiasID)=50)) OR (((orariatbl.orarioID)=False) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID) In (3,4,5)) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias])) OR (((orariatbl.orarioID)=5) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=6) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias])) OR (((orariatbl.orarioID)=False) AND ((eidiyphresiontbl.haraktirismosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboHaraktirismosypiresias] And (eidiyphresiontbl.haraktirismosypiresiasID)=1) AND ((eidiyphresiontbl.eidosypiresiasID)=[Forms]![ypiresiesekdfrm]![cboEidosypiresias] And (eidiyphresiontbl.eidosypiresiasID) In (58,59,60,19)))
ORDER BY orariatbl.Orario;