obtaining a sum in a query

[rpmrob]

This is probably a very basic question, but here goes: I would like to run a query and then provide the sum of records of a field. Can I do this (query and sum) all in one query, or do I have to run a second query (on the original query) to get the sum.

Woa ...

R

 

[SkipVought]

Hi,

Kinda hard to generalize, but here goes...

Select Field1, Sum(Field2)
From MyTable
Group By Field1

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[rdodge]

If you mean like an aggregate sum of some amount by some category/item, yes, you can do this.

Example:

Table: Ledger

Fields: ItemNumber, Qty

Entries in the table are per transaction that takes place with positive quantities being added to what the company has on hand while negative quantities being subtracted from what the company has on hand.

The SELECT Clause of the query would look like:

SELECT ItemNumber, Sum(Qty)
FROM Ledger

Note, the above uses the Aggregate Sum function.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.