Too many records shown in a report 1

[groul]

Hello,
My Access knowledge is not that good to solve following problem: I have two tables/forms. The main form (called "Lib1") includes an embedded form (called "Rev_History", Default View: Data Sheet). Basically the "Lib1" details do not change, but the "Rev_History" details will be updated. So one record of the "Lib1" may refer to more than 1 record in "Rev_History". When I print out a report, only the last revision details should be seen, but it shows all previous revision details too. Here is what can be seen in the SQL View of the query:
SELECT DISTINCT Lib1.BOOK, Lib1.PARTNB, Lib1.MANUAL, Lib1.ATA, Lib1.TITLE, Lib1.VENDOR, Rev_History.Date, Rev_History.Rev
FROM Lib1 INNER JOIN Rev_History ON Lib1.REF = Rev_History.Ref
WHERE (((Lib1.BOOK)=[Forms]![Lib1]![BOOK]))
ORDER BY Lib1.MANUAL;

Can you give me a hint how to correct this.
Thank you
Ulli

 

[hneal98]

Sorry for messing it up first though. Glad it works.