Re: sum time in report based on Stored Procedure
- From: "sack" <sack@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 16 Dec 2005 06:51:03 -0800
The SUM expression I am trying is:
It works like a charm in my .mdb file. I get that aggregate in my .adp
HoursAndMinutes is a user defined function that I snagged from microsoft. I
am thinking that I might have to migrate that function to SQL and use it to
create a column that I can then sum. ....
"Duane Hookom" wrote:
> What "SUM" expression did you try? Did you SUM expression use a field or
> fields from the report's record source? That is what your error message
> seems to be suggesting your issue is.
> Duane Hookom
> MS Access MVP
> "sack" <sack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > When I SUM in my group footer I get:
> > "Aggregate Functions are only allowed on output fields of the record
> > source".
> > thanks for taking a shot at it.
> > "David Lloyd" wrote:
> >> Suzanne:
> >> Have you tried using the "Sorting and Grouping" feature to create a
> >> grouping
> >> on each day and then calculating a total in the group footer? The
> >> following
> >> KB article may be useful in calculating report totals, depending on your
> >> exact circumstances.
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;208850
> >> --
> >> David Lloyd
> >> MCSD .NET
> >> http://LemingtonConsulting.com
> >> This response is supplied "as is" without any representations or
> >> warranties.
> >> "sack" <sack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:2D63BB77-5AD4-4EBE-838F-2213FE71F160@xxxxxxxxxxxxxxxx
> >> ..adp file ----
> >> I have a report based on a Stored Procedure. I am able to get the time a
> >> student spends in the lab each day.
> >> I am unable to get an accumulated total in the report. ie:
> >> 2 hours on Day 1
> >> 4 hours on Day 2
> >> --------------------
> >> 6 total hours ***** can't get the 6 total hours.
> >> any direction would be appreciated,
> >> Suzanne
- Prev by Date: Re: Excluding Report Sections
- Next by Date: Re: Adding boxes in a report.
- Previous by thread: Re: sum time in report based on Stored Procedure
- Next by thread: Re: sum time in report based on Stored Procedure