Return Most Recent Date (1 Viewer)

M

martialtiger

Guest
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

Registered User.
Local time
Today, 14:00
Joined
Feb 8, 2002
Messages
1,115
Your question has been asked before quite often.
I suggest you use the search facility.
Query on "most recent date"

RV
 

kulitmaki

New member
Local time
Today, 07:00
Joined
Jul 22, 2005
Messages
6
martialtiger said:
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;
 

Users who are viewing this thread

Top Bottom