Hi, I have 2 tables in Ms Access. I am doing a tasklist application. I am using left join because I want all the records in the left table to be displayed. I almost get what I want but there is one thing that I cant figure out how to do.
This is my sql statement of the left join..
SELECT SampleTask.taskID, SampleTask.taskTime, SampleTask.taskName, SampleUser.userID, SampleUser.taskStatus FROM SampleTask LEFT JOIN SampleUser ON SampleTask.taskID = SampleUser.taskID WHERE " & strDay & " = true ORDER BY SampleTask.taskTime, SampleTask.taskID
If i put.....WHERE " & strDay & " = true AND SampleUser.taskDate = '28/02/2005'.....then it will return me only the records with 28/02/2005. But that is not what I want.
What I want to display is to show all the tasks for today with the userID regardless of whether they have a record in User if "taskDate = today's date"