Totals query adds ,* to SQL line 1

  • Thread starter Thread starter Ken Pierce
  • Start date Start date
K

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
 
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
 
Back
Top