Print a report where only the last record is choosen 1

[Dophia]

Hi Everyone: I have a one to many relationship. I want a report which prints only the last record of the many side. My data is as follows:

TblOne
ID_# (primary key, no duplicates)(One to many)
Other Info

TblTwo
AssessID (primary key) (autonumber)
ID_# (Primary key) (duplicates ok)(many to one)

So, TblTwo would have many records for a specific ID_#, but I only want the last AssessID to be printed. How can I do this automatically, without specifically choosing the latest AssessID for an ID_#?

Sophia

 

[Remou]

You can base your report on a query, for example:

SELECT tblOne.ID, Max(tblTwo.AssetID) As MaxOfID
FROM tblOne INNER JOIN tblTwo 
   ON tblOne.ID = tblTwo.ID
GROUP BY tblOne.ID

http://lessthandot.com

 

[Dophia]

I don't know why this is working. Here is my actual data. Any help would be appreciated.

SELECT tblAnimals.Pound_Sheet_No, Max(tblAssessment_Details.AssessID) AS MaxOfAssessID
FROM tblAnimals RIGHT JOIN tblAssessment_Details ON tblAnimals.Pound_Sheet_No = tblAssessment_Details.Pound_Sheet_No
GROUP BY tblAnimals.Pound_Sheet_No;

Sophia

 

[Dophia]

I meant to say "it is not working

 

[Dophia]

Sorry, I spoke too soon. It does work!

Thank you Remou.

Sophia