Prev: Database crashes during the process of development
Next: multiple records into one cell
From: iccsi on 3 Jul 2008 15:03
I would like to have a summary on the report footer with individual
details is it possible?

The report like following:

Jun/20 Jun/30 Jul.01
Student 1:

Math 80 85 90
English 70 60 75


Student 2:

Math 75 80 50
English 100 95 60


I need s sum for Math and English like


Math Total: 155 165 140
English Total 170 155 135

Are there any way to do this?

Your help is great appreciated,




From: Duane Hookom on 3 Jul 2008 21:52
You may need to create a totals query similar to your report's record source.
Use this new query as the record source of a subreport to place in your
report's footer.
--
Duane Hookom
Microsoft Access MVP


"iccsi" wrote:

> I would like to have a summary on the report footer with individual
> details is it possible?
>
> The report like following:
>
> Jun/20 Jun/30 Jul.01
> Student 1:
>
> Math 80 85 90
> English 70 60 75
>
>
> Student 2:
>
> Math 75 80 50
> English 100 95 60
>
>
> I need s sum for Math and English like
>
>
> Math Total: 155 165 140
> English Total 170 155 135
>
> Are there any way to do this?
>
> Your help is great appreciated,
>
>
>
>
>
From: iccsi on 4 Jul 2008 07:33
On Jul 3, 9:52 pm, Duane Hookom <duanehookom(a)NO_SPAMhotmail.com>
wrote:
> You may need to create a totals query similar to your report's record source.
> Use this new query as the record source of a subreport to place in your
> report's footer.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
>
> "iccsi" wrote:
> > I would like to have a summary on the report footer with individual
> > details is it possible?
>
> > The report like following:
>
> >                     Jun/20     Jun/30   Jul.01
> > Student 1:
>
> > Math              80               85        90
> > English           70               60       75
>
> > Student 2:
>
> > Math                75              80          50
> > English           100             95           60
>
> > I need s sum for Math and English like
>
> > Math Total:     155              165          140
> > English Total    170             155          135
>
> > Are there any way to do this?
>
> > Your help is great appreciated,- Hide quoted text -
>
> - Show quoted text -

Thanks millions for the information,

 | 
Pages: 1
Prev: Database crashes during the process of development
Next: multiple records into one cell