SELECT Tsalary.FileNo, Tmain.Name, Tsalary.Basic_salary, Tsalary.Change_Salary, Tsalary.Adv_salary, Tsalary.date_Basic, Null AS present_money,NULL AS date1,null as overTime,null as date2,
null as Adv_overTime,null as Data_Basic1,null as Adv_vocation,null as date3
FROM Tsalary INNER JOIN Tmain ON Tsalary.FileNo=Tmain.FileNo
GROUP BY Tsalary.FileNo, Tmain.Name, Tsalary.Basic_salary, Tsalary.Change_Salary, Tsalary.Adv_salary, Tsalary.date_Basic
HAVING (((Tsalary.FileNo)=Forms!Repmap!T1) And ((Tsalary.date_Basic) Between FORMS!Repmap!txtDataStart And FORMS!Repmap!txtEnddata));
UNION All SELECT onepersent.Fileno, Tmain.Name,NULL, NULL, NULL, NULL, onepersent.present_money,onepersent.Data_basic As date1,null,null,null,null,null,null
FROM onepersent INNER JOIN Tmain ON onepersent.Fileno = Tmain.FileNo
GROUP BY onepersent.Fileno, Tmain.Name, onepersent.ID_present, onepersent.ID_salary, onepersent.present_money, onepersent.Data_basic, onepersent.present_money
HAVING (((onepersent.Fileno)=[Forms]![Repmap]![T1]) AND ((onepersent.Data_basic) Between [FORMS]![Repmap]![txtDataStart] And [FORMS]![Repmap]![txtEnddata]));
UNION All SELECT TOverTime.Fileno, Tmain.Name,NULL, NULL, NULL, NULL, null, null,TOverTime.overTime,TOverTime.Data_Basic as date2,null,null,null,null
FROM Tmain INNER JOIN TOverTime ON Tmain.FileNo = TOverTime.Fileno
Where (((TOverTime.Fileno)=[Forms]![Repmap]![T1]) AND ((TOverTime.Data_Basic) Between [FORMS]![Repmap]![txtDataStart] And [FORMS]![Repmap]![txtEnddata]));
UNION ALL SELECT ToverTimeAdv.Fileno, Tmain.Name,NULL, NULL, NULL, NULL, null, null,null,null, ToverTimeAdv.Adv_overTime, ToverTimeAdv.Data_Basic1,null,null
FROM ToverTimeAdv INNER JOIN Tmain ON ToverTimeAdv.Fileno=Tmain.FileNo
GROUP BY ToverTimeAdv.Fileno, Tmain.Name, ToverTimeAdv.Adv_overTime, ToverTimeAdv.Data_Basic1
HAVING (((ToverTimeAdv.Fileno)=Forms!Repmap!T1) And ((ToverTimeAdv.Data_Basic1) Between FORMS!Repmap!txtDataStart And FORMS!Repmap!txtEnddata));
تظهر لة مشكلة فى رسالة خطا data type mismatch in criteria expression ما معنى هذة الرسالة وكيفية حالة ارجوا الرد ضرورى الاستعلام هو query 7
