Results 1 to 6 of 6

Thread: Query Builder

  1. #1
    Join Date
    Jan 2004
    Posts
    145

    Unanswered: Query Builder

    Is there an easy way to get the 'Group By' options to appear in query builder? I think the actual row name is "Total". Right now I goto sql view and type in group by and then go back to design view. It's not a big deal, but it is annoying.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    I believe that as soon as you build an aggregate column you get the Group By option row ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Click on the button with the Greek sum symbol on it in your toolbar
    Inspiration Through Fermentation

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    The only way i can do this is to change the query to crosstab then change back again
    but i much prefer to write the SQL now

  5. #5
    Join Date
    Jan 2004
    Posts
    145
    Thanks guys. My life is better now.

  6. #6
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    There's also View Menu/Totals. Or you could just hit Alt+VL.

Posting Permissions

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