Found an article to solve the issue:
You may receive a "Cannot group on fields selected with '*'" error message when you run a query in Access
SYMPTOMS
When you run a query in a Microsoft Access database that uses one of the aggregate (totals) functions such as the Sum() aggregate function, the Min() aggregate function, or the Max() aggregate function, the query may not run successfully. You may receive the following error message:
Cannot group on fields selected with '*'.
Back to the top
CAUSE
This problem occurs when you use one of the aggregate (totals) functions in your query, and you do not set the Output All Fields query property to No. When you set the Output All Fields query property to Yes, an asterisk (*) wildcard character that represents all columns of the database table is added to the select clause of the Access query. However, you cannot have an asterisk (*) wildcard character together with an aggregate function in the select clause of the Access query. Therefore, when you run the Access query, you may receive the error message that is mentioned in the "Symptoms" section.
Back to the top
RESOLUTION
To resolve this problem, set the Output All Fields query property to No and then run the Access query that uses one of the aggregate (totals) functions. To do this, follow these steps:
1. Start Access.
2. Open the Access database that contains the problem query.
3. In the Database window, click Queries under the Objects section.
4. In the right pane, right-click the problem query, and then click Design View.
5. Click anywhere in the Query window outside the query grid and outside the field lists.
6. On the View menu, click Properties.
7. In the Query Properties dialog box, set the value of the Output All Fields query property to No.
8. On the Query menu, click Run.
Great minds discuss "Ideas"
Average minds discuss "Events"
Below Average minds discuss "People