Report Problems, multiple records on report

[Dynapen]

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

 

[Cornerstone]

Try going back to the query and changing it to a Totals query. Set the total row for your date field to Last.

 

[Dynapen]

Let me clarify. I tried the totals query and it didn't work but i think it's because i didn't clarify what i wanted to begin with. I need my report to show only the most current location for each record, but i need it to show all the records. I have approx 6000 records to track, with the possibility of several past locations on each record. I need to see just the most current location for each record. I might have to go to VB, but that is a foreign language to me.........any help would be appreciated.

 

[Cornerstone]

Did you set the location field to Where in the Totals query? Do that and make the Date field Last then check it.

 

[Halifax]

Go into your query and look at the properties sheet.<br>If you're linking two (or more) tables, look at the Unique Values field. It is currently &quot;NO&quot; Change it to &quot;YES&quot; and run the query. Did duplicate rows dis-appear? They will if ERERY field in the output was the same. If every field is NOT the same, eliminate the fields that are different and you'll reduce the record count as soon as the rowa are the same.<br>