Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

How do I Total Summaries?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dustin - 15 Jan 2008 19:54 GMT
I have a product that has many different options. Ex. 12 rows 30 inch spacing
Red or 8 row 22 inch Spacing Green. I summarized the orders with this
statement in design view of the query. HeadDescription: [Rows]&"
"&[Spacing]&" "&[Color] . I used Group by to summarize them. But now I want
to see the totals of each summary in the next column. Ex. 12 30 Red    20.  
How would I go about that?
Dustin - 15 Jan 2008 20:42 GMT
I figured it out.

Thanks though

> I have a product that has many different options. Ex. 12 rows 30 inch spacing
> Red or 8 row 22 inch Spacing Green. I summarized the orders with this
> statement in design view of the query. HeadDescription: [Rows]&"
> "&[Spacing]&" "&[Color] . I used Group by to summarize them. But now I want
> to see the totals of each summary in the next column. Ex. 12 30 Red    20.  
> How would I go about that?
 
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



©2009 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.