![]() ![]() When you set the Output All Fields property of the query to Yes, an asterisk (*) wildcard character that represents all columns of the database table is added to the select clause of the Access query. This problem occurs when you use aggregate functions in the query, and you do not set the Output All Fields property of the query to No. The error message that you receive is as follow:Ĭannot group on fields selected with '*'. You may receive an error message when you run a query in a Microsoft Access database that uses one of the following aggregate functions: ![]() Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |