Подскажите как сформировать правильно запрос для выборки диапазона дат по нескольким полям

    DataModule1->ADOQuery1->Close();
    DataModule1->ADOQuery1->SQL->Clear();
    DataModule1->ADOQuery1->SQL->Add("SELECT personal.[modif_person], personal.create_person, person_.modif_person, person.create_person 
FROM personal INNER JOIN person ON personal.id_person = person.key_personal_person
WHERE (((personal.modif_person) Between :datastart AND :datastop)) 
OR (((personal.create_person) Between :datastart AND :datastop)) 
OR (((person.modif_person) Between :datastart AND :datastop)) 
OR (((person.create_person) Between :datastart AND :datastop))");
 
DataModule1->ADOQuery1->Parameters->ParamByName("datastart")->Value =FormatDateTime("dd/mm/yyyy",DateTP2->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastop")->Value = FormatDateTime("dd/mm/yyyy",DateTP3->Date);
DataModule1->ADOQuery1->Open();

DataModule1->ADOQuery1->SQL->Add("SELECT personal.[modif_person], personal.create_person, person_.modif_person, person.create_person "); 
DataModule1->ADOQuery1->SQL->Add("FROM personal INNER JOIN person ON personal.id_person = person.key_personal_person ");
DataModule1->ADOQuery1->SQL->Add("WHERE (((personal.modif_person) Between :datastart1 AND :datastop1)) ");
DataModule1->ADOQuery1->SQL->Add("OR (((personal.create_person) Between :datastart2 AND :datastop2)) ");
...

DataModule1->ADOQuery1->SQL->Add("SELECT personal.[modif_person], personal.create_person, person_.modif_person, person.create_person "); 
DataModule1->ADOQuery1->SQL->Add("FROM personal INNER JOIN person ON personal.id_person = person.key_personal_person ");
DataModule1->ADOQuery1->SQL->Add("WHERE (((personal.modif_person) Between :datastart1 AND :datastop1)) ");
DataModule1->ADOQuery1->SQL->Add("OR (((personal.create_person) Between :datastart2 AND :datastop2)) ");
DataModule1->ADOQuery1->SQL->Add("OR (((person.modif_person) Between :datastart3 AND :datastop3)) ");
DataModule1->ADOQuery1->SQL->Add("OR (((person.create_person) Between :datastart4 AND :datastop4))");
 
DataModule1->ADOQuery1->Parameters->ParamByName("datastart1")->Value =FormatDateTime("dd/mm/yyyy",DateTP2->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastop1")->Value = FormatDateTime("dd/mm/yyyy",DateTP3->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastart2")->Value =FormatDateTime("dd/mm/yyyy",DateTP2->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastop2")->Value = FormatDateTime("dd/mm/yyyy",DateTP3->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastart3")->Value =FormatDateTime("dd/mm/yyyy",DateTP2->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastop3")->Value = FormatDateTime("dd/mm/yyyy",DateTP3->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastart4")->Value =FormatDateTime("dd/mm/yyyy",DateTP2->Date);
DataModule1->ADOQuery1->Parameters->ParamByName("datastop4")->Value = FormatDateTime("dd/mm/yyyy",DateTP3->Date);
 
DataModule1->ADOQuery1->Open();