Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 15th, 2008, 05:42 PM
Registered User
Join Date: Dec 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Total Query

I want to calculate the total of a coloumn. Each row of in that record is of one associate.

How to do that.
Below is the data.

Name Total Skus
Xyz 2681
Abc 4698
ERF 512
asf 497
wer 538

I want the sum of "Total Skus" Column.

How has to create that query.



Sudhir KB
Old February 16th, 2008, 05:41 AM
Friend of Wrox
Join Date: Oct 2007
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi

select sum([total skus]) as total_value from tablename


Help yourself by helping someone.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in calculating total sales in MDX query jaee SQL Server 2000 0 March 9th, 2007 11:10 AM
Sub Total Rjh Reporting Services 0 June 21st, 2006 04:11 PM
Problems with multiple total query. cstooch Classic ASP Databases 0 May 14th, 2006 02:09 PM
run total in query stoneman Access 1 December 23rd, 2003 04:43 AM
total columns in sql query nlicata SQL Server ASP 1 August 4th, 2003 06:33 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.