Totals query adds ,* to SQL line 1

[Ken Pierce]

I'm trying to do a totals query in design view, something
I've done a 1000 times and I keep getting < cannot group
on fields selected with '*' >. I have not selected fields
with the * yet when I look at the SQL view, at the end of
the first line is a < ,* >. Like below:

SELECT FuelTransect.PlotID, Count(FuelTransect.Transect)
AS CountOfTransect, *
FROM FuelTransect
GROUP BY FuelTransect.PlotID;


If I delete the , * after the word CountOfTransect, then
my query works. I've been doing queries like this for
years. All of a sudden this problem has cropped up. Any
suggestions?

Thanks

 

[Ken Pierce]

Brilliant. That was exactly it. I've been fighting with
this for hours and its something I do everyday. Thanks so
much for replying.

Ken