I see field, table, sort,show, etc. in the query builder but no to

[Guest]

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.

 

[Duane Hookom]

Select View->Totals

 

[Allen Browne]

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.

 

[Guest]

Thanks for the solution. I am too new for the Access.

 

[Guest]

Thanks for the solution. I am too new for the access I guess.