How to sum in report?

A

Anver

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
 
O

Ofer Cohen

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

Anver

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

Ofer Cohen

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

Anver

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

Ofer Cohen

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

Anver

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

flossie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Reset running sum on group level 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Find then highlight in yellow 6
Monthly Report 5
SUMPRODUCT where between 2 dates 3
Access 2007-Report by Month; Year to Date Total 2
Sum in report 10

Top