Applying Min & Max in Access

[brendanolear]

I have a basic Table of Projects similar to this:

Project Name Month
Proj01 Bob 1
Proj01 Bob 2
Proj01 Bob 3
Proj01 Jack 4
Proj01 Jack 5

I can take table out to excel and add Min & Max formula to present as:

Project Name StartM EndM
Proj1 Bob 1 3
Proj1 Jack 4 5

I cannot however figure out how to do this in access, guidance appreciated

 

[Joe4]

You would use an Aggregate (Totals) Query to do this in Access (you can Google it).

The SQL code for the query would look something like this:

SELECT Projects.Project, Projects.Name, Min(Projects.Month) AS StartM, Max(Projects.Month) AS EndM
FROM Projects
GROUP BY Projects.Project, Projects.Name;

 

[brendanolear]

Thank you Joe4 - works perfectly.

 

[Joe4]

You are welcome.