I keep getting error 3121 when trying to use group by function

[EfrainG]

I am using a table that I improted from excel, but have done nothing else to
modify. The erroro message state "cannot group by object with "*" in
statement. I am doing this in a simple query and using no VBL. What do I
need to do to be able to execute query?

 

[Golfinray]

Go into the query, right click in the area where you put tables, go to
properties, and set output all fields to no.

 

[John W. Vinson/MVP]

I am using a table that I improted from excel, but have done nothing else to
modify. The erroro message state "cannot group by object with "*" in
statement. I am doing this in a simple query and using no VBL. What do I
need to do to be able to execute query?

If there is a column in the query design grid with * as the
fieldname... delete it.