Show results for all, including unmatched

[Gina]

Hello!

I don't know if this is possible, but here goes.

We have a database to track employee's absences, tardies,
etc. I have a report that lists all employees that
have "events" (absences, tardies, leaving early). Is
there a way to create a report that will list ALL the
employees along with their events, as well as those
employees who have no events?

I tried using the unmatched query wizard and then tried to
create a new query based on both the unmatched results and
my events table, but that really didn't work!

Can anyone give me some direction (and pardon my
inexperience)?

Thanks.

 

[John Mishefske]

Hello!

I don't know if this is possible, but here goes.

We have a database to track employee's absences, tardies,
etc. I have a report that lists all employees that
have "events" (absences, tardies, leaving early). Is
there a way to create a report that will list ALL the
employees along with their events, as well as those
employees who have no events?

I tried using the unmatched query wizard and then tried to
create a new query based on both the unmatched results and
my events table, but that really didn't work!

Add the employee table and the event table to your query grid.
Now create a relationship between the two tables on the common
field, most likely an Employee ID (if one doesn't appear
automatically).

Double click on the relationship line to get the Join Properties
window. Set it to retrieve all records from Employees and only
matching records from Events.

Add the fields you need in the query's output and run.

 

[Gina]

John:

Thanks so much! It works great!

Gina

-----Original Message-----


Add the employee table and the event table to your query grid.
Now create a relationship between the two tables on the common
field, most likely an Employee ID (if one doesn't appear
automatically).

Double click on the relationship line to get the Join Properties
window. Set it to retrieve all records from Employees and only
matching records from Events.

Add the fields you need in the query's output and run.


--
'-------------------------------
' John Mishefske
'-------------------------------

.

 

[John Mishefske]

John:

Thanks so much! It works great!

Gina

You're welcome. Good luck on your project.