Missing data from query

[BillyDo]

I have 2 queries- QuerySalary which totals an employees monthly salaries, QueryExpenses which totals the employees expenses. Not all the employees have both expenses and salary so there are some blanks in the data.

I have set up Query3 which I want to total up the totals from QuerySalary and QueryExpenses. I joined the 2 queries with the Employee ID field which is present in both queries.

However- the employee records of those employees who do not have any salaries are not showing in my query. The only records returned in the new query are the ones who have expenses or who have salaries and expenses.

Does anyone know how I can resolve this?

Many thanks

 

[jzwp22]

You need to change the join type in your query. I would probably reconstruct the 3rd query. Add the employee table then the two queries you created with the monthly salary and expenses. Make a join between the employee table and the monthly salary table via the employeeID field. Double click the join line between the table and the query so that the Join Properties menu is shown. You want to select the option that says to include all records from the employee table and only those records from the query that match. Repeat the procedure for the second query.