I have a report based on a query, tracking personnell records. The report needs to display the ID# of the record, the current location, and the date it was checked out. The location is stored in a table, which will have several records on each ID. This is becuase i need to see all the previous locations of the book on one of my forms. The problem comes when i get multiple records for the same ID that show up on the report.<br><br>Example:<br><br>ID# 1, is checked out on 1/1/2000. Returned to files on 2/1/2000, then checked out again on 3/1/2000.<br><br>The report is displaying both the 1/1/2000 and the 3/1/2000 records becuase they moth meet the criteria as far as location. I need to get it to show just the 3/1/2000 record. Help please