Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: ADP Report Problems

    Hi all I have two tables joined in a query and I need for one record to show up in the report rather then the whole history. Does that make sense??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by desireemm
    Does that make sense??
    No, but if you could post the SELECT statment, an example of what you don't want, and a "cut down" example or two of what you do want, I bet we could figure it out!

    -PatP

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by desireemm
    Hi all I have two tables joined in a query and I need for one record to show up in the report rather then the whole history. Does that make sense??
    No ... but if you hum a few bars I think we can fake it

    -- This is all just a Figment of my Imagination --

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    "ADP Report Problem"?
    Should this thread be in the Access forum?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by blindman
    "ADP Report Problem"?
    Should this thread be in the Access forum?
    I thought the same but I was waiting until anyone actually figured out what the problem was.....
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Considering that 95% or better of Desireemm's problems are SQL, I'm willing to give this one the benefit of the doubt. If it turns out that the question belongs elsewhere, we can move it once we know enough to know where to move it to!

    -PatP

  7. #7
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Thank you Pat for Defending me

    I'm so sorry guys I didnt post the Select Statement. You see I have two tables that are joined, the ActiveConditionals table holds the employees conditionals and they could have several of them but I only want to show in my report the most recent ones, from the last two years I would say?/


    Code:
    SELECT     TOP 100 PERCENT dbo.EmployeeGamingLicense.TM#, dbo.EmployeeGamingLicense.LASTNAME, dbo.EmployeeGamingLicense.FIRSTNAME, 
                          dbo.ActiveConditional_tbl.CONDITIONAL, dbo.ActiveConditional_tbl.DATEOFCONDITIONAL, dbo.ActiveConditional_tbl.INVESTIGATOR_COND, 
                          dbo.ActiveConditional_tbl.REASONFORCOND
    FROM         dbo.ActiveConditional_tbl INNER JOIN
                          dbo.EmployeeGamingLicense ON dbo.ActiveConditional_tbl.TM# = dbo.EmployeeGamingLicense.TM#
    ORDER BY dbo.EmployeeGamingLicense.LASTNAME

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    So what do you want. The most recent record, or the records from the past 2 years (possibly multiple records)?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Nevermind

    I figured it out guys I'm sorry to waste your time, your the BEST

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by desireemm
    I figured it out guys I'm sorry to waste your time, your the BEST
    I know - we are that good. Ever so glad we sorted out the problem for you
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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