How to sum in report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Yes, try it and will continue from there
--
Good Luck
BS"D


Anver said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
No, its not ok - it shows #Error
please help



Ofer Cohen said:
Yes, try it and will continue from there
--
Good Luck
BS"D


Anver said:
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 said:
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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
No, its not ok - it shows #Error
please help



Ofer Cohen said:
Yes, try it and will continue from there
--
Good Luck
BS"D


Anver said:
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

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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Thanks man, it was in the page footer.
In report footer it worked perfectly.
Thanks for your time.

Rgds

Ofer Cohen said:
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 said:
No, its not ok - it shows #Error
please help



Ofer Cohen said:
Yes, try it and will continue from there
--
Good Luck
BS"D


:

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

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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top