Displaying null records

[ma0ffst08]

Hi guys,

I have a query which joins 2 tables:

tbl_Analyst and tbl_CompletedJobs, on tbl_Analyst.Analyst = tbl_CompletedJobs.Analyst.

So, what I have are the following fields:

tbl_Analyst.Analyst
tbl_CompletedJobs.WeekCompleted

However, what I need to happen is that if an Analyst has not completed any jobs in a Week, the week displays a 0 against the analyst.

Currently the query only shows weeks which the analyst has completed jobs in.

Any ideas?

 

[alansidman]

I suspect that you need to LEFT join tbl_Analyst on tbl_CompletedJobs.

Open your query in SQL and change INNER join to LEFT join.

Alan