If you use it in a Group Footer, it will automatically limit the Sum to the
values that apply to that Group. You will, of course, have to use the
Report's Sorting and Grouping to set up the Groups.
An alternative would be to use the DSum domain aggregate function if it
isn't feasible to set up Groups, or embed Subreports based on a Totals
Query.
Larry Linson
Microsoft Access MVP
"John" <John@nospam.infovis.co.uk> wrote in message
news:404b9933$0$10141$cc9e4d1f@news.dial.pipex.com ...[color=blue]
> Does sum support some sort of condition I can use to get only records that
> meet a certain field value?
>
> Thanks
>
> Regards
>
>
> "Mike Storr" <storrboy@sympatico.ca> wrote in message
> news:T0K2c.2202$j05.36616@news20.bellglobal.com...[color=green]
> > Use the Sum() function as a textbox ControlSource on the report.
> >
> > Mike Storr
> >
www.veraccess.com
> >
> >
> > "John" <John@nospam.infovis.co.uk> wrote in message
> > news:404b4e35$0$10152$cc9e4d1f@news.dial.pipex.com ...[color=darkred]
> > > Hi
> > >
> > > I want to get the sum of records based on a specific record filter[/color][/color]
> (field[color=green][color=darkred]
> > > value), in addition to the report total which is the sum of all[/color][/color][/color]
records.[color=blue][color=green]
> > Is[color=darkred]
> > > there a way to do that in a report?
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
