Calculation Query

  • Thread starter Jeff F via AccessMonster.com
  • Start date
J

Jeff F via AccessMonster.com

Thanks in advance for any assistance. I have a db that tracks certain
projects. Each project has a particular phase (phase 1, phase 2, phase 3,
phase 4) of completion as well a project $ estimate. I need a form based on
a query Im guessing that will produce a summary of the projects. I need (1)
a count of the projects in each phase and (2) the sum of the $ estimates for
each phase.

I would expect the output to look like:

Phase Count Sum of $
1
2
3
4

I am not very adept with VB and code and do most all work in query or form
design modes with macros.

Thanks again for any assistance.
 
K

KARL DEWEY

SELECT [YourTable].Phase, Count([YourTable].Phase) AS CountOfPhase,
Sum([YourTable].Phase) AS SumOfPhase
FROM [YourTable]
GROUP BY [YourTable].Phase;
 
Top