Top Ten Date Query

  • Thread starter Thread starter Bryan Hughes
  • Start date Start date
B

Bryan Hughes

Hello,

I need to set up a query that retrives the top ten results of the most
recent dates entered.

My query currently looks like this.

SELECT TOP 10 tblCase_File_Status.CFID, tblCase_File_Status.SCD,
tblCase_File_Status.SC, tblCase_File_Status.ACM
FROM tblCase_File_Status
GROUP BY tblCase_File_Status.CFID, tblCase_File_Status.SCD,
tblCase_File_Status.SC, tblCase_File_Status.ACM, tblCase_File_Status.CSID
HAVING (((tblCase_File_Status.CFID)=[Reports]![rptCase_File]![CFID]))
ORDER BY tblCase_File_Status.SCD;

// .SCD is date field

So to this query I need to get the most recent entries by date.

Example:
05/25/2005
05/01/2005
04/12/2005
01/6/2005
11/25/2004
etc.

-TFTH
Bryan
 
Does this mean you want the top 10 results for each of the most recent
dates entered, or the top 10 results from any of the most recent dates
entered?

Also, what is the definition of "recent entries" when it comes to dates?
 
Back
Top