Way to keep older reports from showing on query?

[spudracer]

I might have asked this before, but don't remember.

I have a query that pulls a listing of personnel where I track their pending transfer date and any subsequent reports or other paperwork we need on them prior to their transfer.

As of right now it will display every single annual report they have received (that's in my database) which results in duplicate entries for each person (if they have more than one report).

I want the query to only pull the most recent one without having to specify a specific date span. Is there a way to do this?

 

[MSAccessRookie]

Look at the Function Max() and see if it is what you are looking for. Also, remember that since Max() is a Grouping Function, it requires a Group By qualifier in the SQL Statement to work the way that you want to use it.