Record source - showing records ?

[CdRsKuLL]

I am creating a holiday planner and want to show all the employee's on a continuous form (month view). Is there anyway to force a record to appear even if it fails the sql statement ? The reason being is that I want to show all the employee's even if they are not having any time off in that month ?

My sql statement is..

SELECT tblEmployee.*, tblHoliday.*, [surname] & ", " & [firstname] AS name, tblHoliday.holidaymonth
FROM tblEmployee INNER JOIN tblHoliday ON tblEmployee.ID = tblHoliday.employee
WHERE (((tblHoliday.holidaymonth)=getdate()));

The getdate function filters the statement by the current month. The trouble is it only displays employee's that have time off in that month.


many thanks

Steve

 

[pbaldy]

Try changing INNER to LEFT.