Error: Cannot group on Fields selected with '*'.

[pedie]

'm getting Error: Cannot group on Fields selected with '*'. when trying to use sum query....
Why is this happening?

 

[Norie]

Because you can't group on fields selected with *?

If you are doing this in the query designer just select all the fields you want from the table and drag them from the list down to the field row.

Then from the dropdown select Sum/Count for the fields you want to count.

PS That's assuming you are using the query designer.

 

[pedie]

Because you can't group on fields selected with *?

If you are doing this in the query designer just select all the fields you want from the table and drag them from the list down to the field row.

Then from the dropdown select Sum/Count for the fields you want to count.

PS That's assuming you are using the query designer.

Hi Noriw, you're right...me, 'm using the query designer...
I tried that way but still errors...

[/FONT]
[FONT=Courier New]SELECT Count(Months.ID) AS CountOfID, Count(Months.MyMOnths) AS CountOfMyMOnths, Count(Months.UserNames) AS CountOfUserNames, Sum(Months.REVS) AS SumOfREVS, *
FROM Months;

 

[Norie]

You've still got the *.

Delete the column where the field row has Months.*.

 

[pedie]

I dont know where 'm doing it wrong...
I have removed all the cols....just rev col is remaining....still errors...

 

[Norie]

Pedie

Why not just abandon the query and start over?

 

[pedie]

k. lemmi try again...

 

[pedie]

SELECT Sum(Months.rEVS) AS SumOfrEVS, *
FROM Months;


I tried all over again and wont work...

 

[Joe4]

As Norie has said numerous times, remove the "*".

SELECT Sum(Months.rEVS) AS SumOfrEVS
FROM Months;

 

[pedie]

As Norie has said numerous times, remove the "*".

 [/FONT]
[FONT=Courier New]SELECT Sum(Months.rEVS) AS SumOfrEVS[/FONT]
[FONT=Courier New]FROM Months;[/FONT]
[FONT=Courier New] [/FONT]
[FONT=Courier New]

Now it does not error...however I like to add multiple conditions to sum 5 conditions actually....how can i do tha like sumifs in Excel.

Thanks again for helping