How Can I find the date of each Last Report

[Robert Gillard]

I have a table of Reports sent, which as the name suggests details each time
a report is sent out.(So if a report went out on the 1st off the month, it
would be listed 3 times for this year 1st Jan, 1st Feb, 1st March) Two of
the Fields are RepName and DateSent.

There are approx 80 reports that are run every month (some reports are sent
weekly), I would like to query the table to find the last date that each
report was sent. So I would end up with a list of 80 (different reports) and
the date on which they were last sent out.

Is this possible please, if not are there any other options.

Bob

 

[Dan Artuso]

Hi,
You would have a query that looks something like this:

Select RepName, Max(DateSent) As LastSent From yourTable Group By RepName