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
GROUP BY Production.PROJECT_ID;
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,
Brian
