3 Replies Latest reply: Jan 3, 2013 4:20 PM by obedadames RSS

    Need Help creating a report

      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.