FIlter Information on Report

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am running a report and I want the ouput to be th emost recent date
asscociate with a record. An expample is the data has an case number in 1
column with various dates associated it in another column. I want the report
to printout the case number with the most recent date. So if case number
1234 has June 1, 2009 and June 2, 2009, it should printout case number 1234
in column A and June 2, 2009 in columnB.

How can create the selection criteria? Thank you in advance!
 
I am running a report and I want the ouput to be th emost recent date
asscociate with a record. An expample is the data has an case number in 1
column with various dates associated it in another column. I want the report
to printout the case number with the most recent date. So if case number
1234 has June 1, 2009 and June 2, 2009, it should printout case number 1234
in column A and June 2, 2009 in columnB.

How can create the selection criteria? Thank you in advance!
Click to expand...

Create a query to filter the records.

SELECT YourTable.[CaseNumber], Max(YourTable.[CaseDate]) AS
MaxOfCaseDate
FROM YourTable
GROUP BY YourTable.[CaseNumber];

Change the table and field names to whatever your actual names are.

Make this query the record source for your report.
 
Back
Top