possible to know the sum of a column without running a new query?

D

Dave K

Hello - Is there a way to find the sum of a column in a given query or
table without running a new query?

Thanks.
 
R

Rick Brandt

Dave said:
Hello - Is there a way to find the sum of a column in a given query or
table without running a new query?

Thanks.
Click to expand...

You could use the DSum() function. That does actually run a query to do its
job, but if you meant "without running a new query that I have to build"
then that would do it.
 
A

aaron.kempf

DSum would work-- you also can do subqueries.

My reccollection of subqueries with Access is this--
You can add a subquery and then 'presto' when Access decides that your
query is 'too complex' then it will through a tissy-fit.

That is one of my biggest complaints about MDB.

But you _SHOULD_ be able to do somehting like this

Select OD.*,
(Select Name From Employees E where E.EmployeeID =
OD.SalesPersonID) as SalesPersonName
From OrderDetails OD

Hope that helps--

-Aaron
 
Top