Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    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.

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Hi Kenny

    What happens if you check the SQL? Is the group by * in there?
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts