R
RMort
I have 2 tables, one contains a list of Job Tasks and the other contains a
list of Employees, the Date they worked the Job Task and amount of time
spent, in hours, on the Job Task. I currently have a query that will total
the hours spent on each Job Task for a date range, but the data changes on a
month to month basis. Some months there might not be any hours spent on a
particular task. However the Excel spreadsheet that I'm pasting the data
into needs to list all job tasks that we have regardless if it was worked
that month or not. I would like to have the query provide me with a list of
all tasks and if there is no data for the requested month, then just have a
zero for the hours worked. I tried a Left Join, but the query is still only
showing me the Job Task that occurred within the requested date range.
list of Employees, the Date they worked the Job Task and amount of time
spent, in hours, on the Job Task. I currently have a query that will total
the hours spent on each Job Task for a date range, but the data changes on a
month to month basis. Some months there might not be any hours spent on a
particular task. However the Excel spreadsheet that I'm pasting the data
into needs to list all job tasks that we have regardless if it was worked
that month or not. I would like to have the query provide me with a list of
all tasks and if there is no data for the requested month, then just have a
zero for the hours worked. I tried a Left Join, but the query is still only
showing me the Job Task that occurred within the requested date range.