Show an Employee with no reviews

  • Thread starter Thread starter Tina S
  • Start date Start date
T

Tina S

I have a table with a list of all employees. I have another table that shows
the reviews done on the employees.

I have a crosstab query to show me how many reviews were completed on each
employee each quarter and then the total for the year.

The problem I have is there are employees who have no reviews completed and
they are not showing up in the table. I need to show them because they
should have had reviews and I need to show they have had none.

I joined the table and took the employee name from the employee table and
did a join to show all the employees on the employee table, but if there are
no reviews they are not showing.
 
In the query design view double click on the line between the two tables.
When the dialog box appears, select the second option.
 
Tjis is whatI ave already done and it is still not working.
it says,
"Include ALL records from 'ALL_EMP' and only those records from
'Comp_Rev' where the join fields are equal.
 
Tina said:
I have a table with a list of all employees. I have another table that shows
the reviews done on the employees.

I have a crosstab query to show me how many reviews were completed on each
employee each quarter and then the total for the year.

The problem I have is there are employees who have no reviews completed and
they are not showing up in the table. I need to show them because they
should have had reviews and I need to show they have had none.

I joined the table and took the employee name from the employee table and
did a join to show all the employees on the employee table, but if there are
no reviews they are not showing.
Click to expand...


You need to use an outer join. In the query designer,
select the line between the two tables. The right click the
line and change the join type to the one that selects all
records from the employee table and any matching records
from the reviews table.
 
I already did this and it is still not working.
it says,
"Include ALL records from 'ALL_EMP' and only those records from
'Comp_Rev' where the join fields are equal.
 
Post the SQL of your query by opening in design view, clicking on VIEW - SQL
View, highlight all ,copy, and paste in a post.
 
It's the crosstab. Without data, there's nothing to tranform.

Try creating a regular select query, with the same kind of join, and using
something like the NZ function to return a 0 instead of a null. Then use that
query as the record source for the crosstab query.
 
Back
Top