How to sum in report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anver - 29 Mar 2007 10:28 GMT

ID Number Price Date SuppPrice Profit
20 1401 100 15/3/07 75 25
21 1402 150 16/3/07 110 40
22 1403 200 17/03/07 150 50

I have the above tables, I need the total price of the 3 order in the report
and total of the suppier price and also total profit in the report
any way to do this in the report - I am new Access and I use Access 2003

Please help

Reply to this Message

Ofer Cohen - 29 Mar 2007 13:20 GMT

To display the sum of ew records in the report you need to use the Sum function

In the Report footer add three text boxes, and each text box control source
add

=Sum([Price])

To get the total price.

Do the same to get the sum for all the other fields.

Signature

Good Luck
BS"D

> ID Number Price Date SuppPrice Profit
> 20 1401 100 15/3/07 75 25
[quoted text clipped - 6 lines]
>
> Please help

Reply to this Message

Anver - 29 Mar 2007 21:38 GMT

Dear

You mean like this
=Sum([Price]) for Total price
=Sum([SuppPrice]) for Total supplier price
=Sum([Profit]) for total profit

Please advise

Rgds

> To display the sum of ew records in the report you need to use the Sum function
>
[quoted text clipped - 17 lines]
> >
> > Please help

Reply to this Message

Ofer Cohen - 30 Mar 2007 00:18 GMT

Yes, try it and will continue from there

Signature

Good Luck
BS"D

> Dear
>
[quoted text clipped - 28 lines]
> > >
> > > Please help

Reply to this Message

Anver - 30 Mar 2007 08:16 GMT

No, its not ok - it shows #Error
please help

> Yes, try it and will continue from there
>
[quoted text clipped - 30 lines]
> > > >
> > > > Please help

Reply to this Message

Ofer Cohen - 30 Mar 2007 12:20 GMT

Make sure that the Sum text box located in the report footer and not the
page footer
The Page footer will give you error

Also, make sure that the sum include the name of the field in the table

=Sum([Name of field in the table])

Make sure that the text box name doesn't have the same name as the name of
the field in the table

Signature

Good Luck
BS"D

> No, its not ok - it shows #Error
> please help
[quoted text clipped - 33 lines]
> > > > >
> > > > > Please help

Reply to this Message

Anver - 30 Mar 2007 22:04 GMT

Thanks man, it was in the page footer.
In report footer it worked perfectly.
Thanks for your time.

Rgds

> Make sure that the Sum text box located in the report footer and not the
> page footer
[quoted text clipped - 44 lines]
> > > > > >
> > > > > > Please help

Reply to this Message