Unanswered: Cannot group on fields selected with '*' - ?
Hi. I'm developing an aggregate query to use with a sales records table. I'm going through DesignView, selecting my table, clicking close. I then double click the first field I need it, then I select Totals to total by "Group By" I am then entering some formulas to summarize sales by month/year, etc. When I run the query, though, I'm getting this message - CANNOT GROUP BY FIELDS SELECTED BY "*". I'm not even selecting the asterisk when I selected the field - I'm double clicking the specific field itself. What gives? Has anyone else had this to happen? If so, is there a bypass or solution? Thanks.