Date filter in Report

  • Thread starter Thread starter David Brown
  • Start date Start date
D

David Brown

I have a table of "jobs" and a related table of "minutes"
that we enter data in during a meeting for each job. What
I would like to do is print off a report that has the last
minute entry for each job. But they will not necessarily
all have the same entry date. We don't always talk about
every job. The report should show the last entry for each
job.

How would I filter this?
 
Use the value of maximum date for each job. If there aren't a lot of records
in the table, the DMax function probably is the easiest way to return the
max value for each job. Otherwise, I'd use a separate query that gets the
max date for each job, and then join a query to that query.
 
Back
Top