Re: sum time in report based on Stored Procedure

Hi Duane,

The SUM expression I am trying is:

=HoursAndMinutes(Sum([CheckOut]-[CheckIn]))

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

thanks, Suzanne



"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
> news:DBCF1A64-77ED-4590-ABFF-FA10C7419169@xxxxxxxxxxxxxxxx
> > 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
> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: sum time in report based on Stored Procedure
    ... What "SUM" expression did you try? ... Did you SUM expression use a field or ... fields from the report's record source? ... >> I have a report based on a Stored Procedure. ...
    (microsoft.public.access.reports)
  • sum wont update
    ... I have a sum expression in the footer of a subform to ... When the database is opened by a new computer running Windows 7 the sum ... expression will not recalculate changes made to records in the detail section ...
    (microsoft.public.access.forms)
  • Re: how can i adapt this formula?
    ... the formula in the other response works all the time. ... > If I understand your formula, you are trying to sum the value of the cells ... > It returns the sum of the range if the sum expression does not evaluate to ...
    (microsoft.public.excel.programming)
  • Re: Sum in form footer
    ... You cannot reference the name of a control in the Sum expression; ... (the SubTotal/Taxes/Total control are all calculated fields) ...
    (microsoft.public.access.forms)
  • Re: how can i adapt this formula?
    ... you are trying to sum the value of the cells ... It returns the sum of the range if the sum expression does not evaluate to an ... you can separate discontinuous ranges with a comma. ... "Gary Keramidas" wrote: ...
    (microsoft.public.excel.programming)