smtazulislam
Member
- Local time
- Today, 04:56
- Joined
- Mar 27, 2020
- Messages
- 806
Hello, any help much appreciate..
I try to this column null filed display in the report. for that I try to create a query and put critaria "IsNull" and also "Is Not Null" or "Not Is Null"
But result dont display null field record.
its always display entry fields...
Any idea !
Code:
SELECT tblEmployeeSalaries.SalaryID, tblEmployeeSalaries.EmployeeID, tblEmployee.EmployeeName, tblEmployee.DeptID, tblEmployee.CountryID, tblEmployeeSalaries.DateFrom, tblEmployeeSalaries.Basic, tblEmployeeSalaries.Food, tblEmployeeSalaries.Others, tblEmployeeSalaries.Increase, tblEmployeeSalaries.sGrossSalary, tblEmployeeSalaries.Note, LtblAllowaceType.AllowanceType, tblAllowanceData.TotalAllowance, tblAllowanceData.AllowanceTypeID
FROM (tblEmployee INNER JOIN (tblAllowanceData INNER JOIN LtblAllowaceType ON tblAllowanceData.AllowanceTypeID = LtblAllowaceType.AllowanceTypeID) ON tblEmployee.EmployeeID = tblAllowanceData.EmployeeID) INNER JOIN tblEmployeeSalaries ON tblEmployee.EmployeeID = tblEmployeeSalaries.EmployeeID;
Code:
tblAllowanceData.TotalAllowance
its always display entry fields...
Any idea !