 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2006I see field, table, sort,show, etc. in the query builder but no to
when I build a query in design view using query builder. I can see all the criteria fields like field, table, sort, show, criteria, or but there is no total found in that builder. I want to build a query with group by function. I am not able to do that because of this. Select View->Totals  SignatureDuane Hookom MS Access MVP > when I build a query in design view using query builder. I can see all the > criteria fields like field, table, sort, show, criteria, or but there is > no > total found in that builder. I want to build a query with group by > function. > I am not able to do that because of this. Thanks for the solution. I am too new for the Access. > Select View->Totals > [quoted text clipped - 4 lines] > > function. > > I am not able to do that because of this. To add the Total row to the query design window, depress the Total button on the toolbar (upper sigma icon), or click Total on the View menu. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > when I build a query in design view using query builder. I can see all the > criteria fields like field, table, sort, show, criteria, or but there is > no > total found in that builder. I want to build a query with group by > function. > I am not able to do that because of this. Thanks for the solution. I am too new for the access I guess. > To add the Total row to the query design window, depress the Total button on > the toolbar (upper sigma icon), or click Total on the View menu. [quoted text clipped - 5 lines] > > function. > > I am not able to do that because of this. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.