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
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