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??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|||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 :D|||"ADP Report Problem"?
Should this thread be in the Access forum?|||"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....|||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|||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?/

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|||So what do you want. The most recent record, or the records from the past 2 years (possibly multiple records)?|||I figured it out guys I'm sorry to waste your time, your the BEST|||I figured it out guys I'm sorry to waste your time, your the BESTI know - we are that good. Ever so glad we sorted out the problem for you :D