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

[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.

 

[Rick Brandt]

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

Thanks.

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.

 

[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