Results 1 to 4 of 4

Thread: Urgent Query

  1. #1
    Join Date
    Aug 2009
    Posts
    37

    Unanswered: Urgent Query

    i have tables like this

    Leaves Table

    lid refid leaveappliedon leavefrom leaveto

    1 101 16/04/2010 16/04/2010 22/04/2010

    attendance table

    Aid refid intime outtime attendace

    1 101 15/04/2010 10:00AM 15/04/2010 5:00PM p
    2 101 17/04/2010 10:00AM 17/04/2010 5:00PM p
    3 101 18/04/2010 10:00AM 18/04/2010 5:00PM p


    from frontend user will give two dates example if user wants to see weekely report,he will give two dates i want out put like

    this



    example: user selected dates like this 15/04/2010 and 22/04/2010

    in aboue tables "refid 101" was leave on 16/04/2010 so i need output like this
    if dates in saturday and sunday no need to count

    date attendance

    15/04/2010 P
    16/04/2010 L
    17/04/2010 P
    18/04/2010 P
    19/04/2010 P
    20/04/2010 P

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    So...what have you got so far?

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    How did you get values for the 19th and 20th? They aren't anywhere I can see in your input data.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Aug 2009
    Posts
    37
    If there is no records between selected dates empty should be displayed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •