Total Query

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Total Query

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

kbsudhir

kbsudhir is offline

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.

:(:(

Thanks
Sudhir

Sudhir KB

Old

February 16th, 2008, 05:41 AM

urtrivedi

urtrivedi is offline

Friend of Wrox

Join Date: Oct 2007

Posts: 130

Thanks: 0

Thanked 3 Times in 3 Posts

Send a message via AIM to urtrivedi

Default

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

urt

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