Summing records query(ies) help?

By corujo ·
Ok, I'll try to make this as coherent as I can. I'm not a DB guy(yet), but I need to get some data arranged before I can use it in GIS.
MS Access 2007
This is what I have so far:

SELECT Production.ProjectID, Project.ProjectName, Project.StatusID, Project.ActivityID, Project.PrimaryMO, Production.MeasuredMetal1ID, Production.MeasuredGrade1, SUM(Production.Produced1)
FROM Production, Project
WHERE Production.METAL_ID1 = 485

I get this error. "You tried to execute a query that does not include the specified experssion 'ProjectID' as part of an aggregate function."
Thanks in advance,

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums