Hi, I need a little of help creating a report
I want to create a report that compare and show what person was not available in a day.
I have two tables one is a master that have all the people and another one that have the assistant (have name, id, date and hour, etc.)
I want to create a report by date, week, and month
I will appreciate all your help.
MASTER
ID | NAME | LNAME | OFFICE |
001 | JOSE | DIAZ | 002 |
002 | MARIA | LOPEZ | 001 |
003 | JOHN | QUE | 001 |
004 | LUI | BOCH | 003 |
005 | PETER | PAN | 001 |
ASSISTANCE
ID | ENTER | EXIT | HOUR |
001 | 1/1/2013 10:00 | 1/1/2013 15:00 | 5 |
002 | 1/1/2013 10:00 | 1/1/2013 15:00 | 5 |
003 | 1/1/2013 10:00 | 1/1/2013 15:00 | 5 |
004 | 1/1/2013 10:00 | 1/1/2013 15:00 | 5 |
005 | 1/1/2013 10:00 | 1/1/2013 15:00 | 5 |
001 | 1/2/2013 10:00 | 1/2/2013 15:00 | 5 |
002 | 1/2/2013 10:00 | 1/2/2013 15:00 | 5 |
004 | 1/2/2013 10:00 | 1/2/2013 15:00 | 5 |
005 | 1/2/2013 10:00 | 1/2/2013 15:00 | 5 |
001 | 1/3/2013 10:00 | 1/3/2013 15:00 | 5 |
002 | 1/3/2013 10:00 | 1/3/2013 15:00 | 5 |
003 | 1/3/2013 10:00 | 1/3/2013 15:00 | 5 |
004 | 1/3/2013 10:00 | 1/3/2013 15:00 | 5 |
001 | 1/4/2013 10:00 | 1/4/2013 15:00 | 5 |
003 | 1/4/2013 10:00 | 1/4/2013 15:00 | 5 |
005 | 1/4/2013 10:00 | 1/4/2013 15:00 | 5 |
What I need:
What are the people that don’t assist on a date.
