Discussion Groups Home

How to sum in report? in Access Database Reports

3/29/2007 2:26 AM PST

Question

	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

Was this post helpful to you?

Top

Ofer Cohen

3/29/2007 5:18 AM PST

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.

--
Good Luck
BS"D

"Anver" wrote:

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

Was this post helpful to you?

Top

Anver

3/29/2007 1:36 PM PST

Dear

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

Please advise

Rgds

"Ofer Cohen" wrote:

> 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.
>
> --
> Good Luck
> BS"D
>
>
> "Anver" wrote:
>
> > 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
> >
> >

Was this post helpful to you?

Top

Ofer Cohen

3/29/2007 4:17 PM PST

Yes, try it and will continue from there
--
Good Luck
BS"D

"Anver" wrote:

> Dear
>
> You mean like this
> =Sum([Price]) for Total price
> =Sum([SuppPrice]) for Total supplier price
> =Sum([Profit]) for total profit
>
> Please advise
>
> Rgds
>
>
> "Ofer Cohen" wrote:
>
> > 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.
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "Anver" wrote:
> >
> > > 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
> > >
> > >

Was this post helpful to you?

Top

Anver

3/30/2007 12:15 AM PST

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

"Ofer Cohen" wrote:

> Yes, try it and will continue from there
> --
> Good Luck
> BS"D
>
>
> "Anver" wrote:
>
> > Dear
> >
> > You mean like this
> > =Sum([Price]) for Total price
> > =Sum([SuppPrice]) for Total supplier price
> > =Sum([Profit]) for total profit
> >
> > Please advise
> >
> > Rgds
> >
> >
> > "Ofer Cohen" wrote:
> >
> > > 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.
> > >
> > > --
> > > Good Luck
> > > BS"D
> > >
> > >
> > > "Anver" wrote:
> > >
> > > > 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
> > > >
> > > >

Was this post helpful to you?

Top

Ofer Cohen

3/30/2007 4:18 AM PST

Answer

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
--
Good Luck
BS"D

"Anver" wrote:

> No, its not ok - it shows #Error
> please help
>
>
>
> "Ofer Cohen" wrote:
>
> > Yes, try it and will continue from there
> > --
> > Good Luck
> > BS"D
> >
> >
> > "Anver" wrote:
> >
> > > Dear
> > >
> > > You mean like this
> > > =Sum([Price]) for Total price
> > > =Sum([SuppPrice]) for Total supplier price
> > > =Sum([Profit]) for total profit
> > >
> > > Please advise
> > >
> > > Rgds
> > >
> > >
> > > "Ofer Cohen" wrote:
> > >
> > > > 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.
> > > >
> > > > --
> > > > Good Luck
> > > > BS"D
> > > >
> > > >
> > > > "Anver" wrote:
> > > >
> > > > > 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
> > > > >
> > > > >

Was this post helpful to you?

Top

Anver

3/30/2007 2:03 PM PST

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

Rgds

"Ofer Cohen" wrote:

>
> 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
> --
> Good Luck
> BS"D
>
>
> "Anver" wrote:
>
> > No, its not ok - it shows #Error
> > please help
> >
> >
> >
> > "Ofer Cohen" wrote:
> >
> > > Yes, try it and will continue from there
> > > --
> > > Good Luck
> > > BS"D
> > >
> > >
> > > "Anver" wrote:
> > >
> > > > Dear
> > > >
> > > > You mean like this
> > > > =Sum([Price]) for Total price
> > > > =Sum([SuppPrice]) for Total supplier price
> > > > =Sum([Profit]) for total profit
> > > >
> > > > Please advise
> > > >
> > > > Rgds
> > > >
> > > >
> > > > "Ofer Cohen" wrote:
> > > >
> > > > > 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.
> > > > >
> > > > > --
> > > > > Good Luck
> > > > > BS"D
> > > > >
> > > > >
> > > > > "Anver" wrote:
> > > > >
> > > > > > 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
> > > > > >
> > > > > >

Was this post helpful to you?

Top

flossie

6/9/2009 7:29 PM PST

I am using 2007 access. What if I am trying to get the grand total for
'Price'; 'SuppPrice'; and 'Profit' - what expression do I use?

"Anver" wrote:

> Dear
>
> You mean like this
> =Sum([Price]) for Total price
> =Sum([SuppPrice]) for Total supplier price
> =Sum([Profit]) for total profit
>
> Please advise
>
> Rgds
>
>
> "Ofer Cohen" wrote:
>
> > 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.
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "Anver" wrote:
> >
> > > 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
> > >
> > >

Was this post helpful to you?

Top

	Return to Microsoft Communities		Notify me of replies