[shabbir]

I am not sure if its possible in Access because it needs subquery and if its allowed it can be done as follows.

SELECT TOP n issued.issue_id, issued.issue_date FROM issued WHERE file_id IN (SELECT file_id FROM issued ) ORDER BY issued.issue_id DESC

If it does not allow the sub queries then you need to be taking the file_id and then put it in the "IN CALUSE".