=========Error Message(s):---------Error message when you run a query in Access: "Cannot group on fields selected with '*'" ---------All fields showing in query results even though you only stipulated a few =========REF:---------http://www.pcreview.co.uk/forums/asterisk-automatically-added-end-query-sql-vie-t3283725.html  ---------http://support.microsoft.com/kb/835414  =========ANSWER(S): ---------To resolve this problem, set the Output All Fields property of the query to No, and then run the Access query that [...]