Return Most Recent Date

[martialtiger]

Using MS Access XP

Here's the scenario. I have 3 fields [AgentID], [QA Date], [Points Issued]. What I want to do is run a query that will give me the last date [QA Date] a point [Points Issued] was issued for each agent [AgentID]. And I want the query to display all 3 fields according. Is this possible?

 

[RV]

Your question has been asked before quite often.
I suggest you use the search facility.
Query on "most recent date"

RV

 

[kulitmaki]

Using MS Access XP

Here's the scenario. I have 3 fields [AgentID], [QA Date], [Points Issued]. What I want to do is run a query that will give me the last date [QA Date] a point [Points Issued] was issued for each agent [AgentID]. And I want the query to display all 3 fields according. Is this possible?

SELECT Table1.a_id, Max(Table1.date) AS MaxOfdate, Sum(Table1.points) AS SumOfpoints
FROM Table1
GROUP BY Table1.a_id;