[RESOLVED] Simple question (Group By)

[DubweiserTM]

Hi everybody !

I want to Select all fields and group by one field, like the code below, but I got an error ?

I dont want to write all fields because there are too many...Is there a way to do that ?

strSQL = "SELECT * FROM Items WHERE BComm = ?" & " GROUP BY BCommNo"

Thanks in advance !