Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It somewhat depends on how exactly you want to display the results. The attached example will create a Worked =Y/N flag for every combination of ENTER dates and ID. You can use that as a filter.
-Rob
I will appreciate any help
Thanks
It somewhat depends on how exactly you want to display the results. The attached example will create a Worked =Y/N flag for every combination of ENTER dates and ID. You can use that as a filter.
-Rob
Thanks it realy helps a lot