Running totals in Project file?

[Maddman]

I'm in the process of converting an Access database into a SQL 2000
database using Access Project as a front end. Here's where I'm stuck.

I've replaced the old access queries with user-defined functions in SQL
(because I need to pass parameters back and forth). Its all working
great. However, at the bottom of the report I often have a field for
totals - for instance, a field showing the number of items in each
product code, then at the bottom a field that sums up the entire
column. The number of all items. In Access, I did this with a simple
=Sum(CountOfProductCode). In a Project, I've just learned, this is
forbidden! You can't use aggregate functions at all! I can't even add
it up in another SQL function and get to it with a domain aggregate
function!

How can you add a total to the bottom of a report in a Project, if
aggregate functions are not useable?

TIA,

maddman

[Elaine]

SQL, SQL, SQL, as in

SELECT SUM(ColumnOfInterest) as SumName FROM TableOfInterest Where
Conditions = ConditionsForReport

Also, it may be helpful to spend some time understanding what Report
events fire and when they fire.

HTH
On 18 Mar 2005 13:19:03 -0800, "Maddman" <ma********@yahoo.com> wrote:

I'm in the process of converting an Access database into a SQL 2000
database using Access Project as a front end. Here's where I'm stuck.

I've replaced the old access queries with user-defined functions in SQL
(because I need to pass parameters back and forth). Its all working
great. However, at the bottom of the report I often have a field for
totals - for instance, a field showing the number of items in each
product code, then at the bottom a field that sums up the entire
column. The number of all items. In Access, I did this with a simple
=Sum(CountOfProductCode). In a Project, I've just learned, this is
forbidden! You can't use aggregate functions at all! I can't even add
it up in another SQL function and get to it with a domain aggregate
function!

How can you add a total to the bottom of a report in a Project, if
aggregate functions are not useable?

TIA,

maddman