Run-Time error 3122 1

[Brianus]

In VBA, I tried to execute the code below:

SELECT Projid, projstatus, projdescription, Sum(tothrs) FROM Timesheettbl
GROUP BY Projid;

And I get the following error message:
You tried to execute a query without including Projstatus as an aggregage function.

How can I solve this problem?
Thank you all for any help.
Brianus.

 

[jebry]

Hi!

Like this:

SELECT Projid, projstatus, projdescription, Sum(tothrs) FROM Timesheettbl
GROUP BY Projid, projstatus, projdescription;

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst