The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

This discussion is now closed.

Check out other Related discussions

Help me to solve this question

SOLVED

The question is :
Your report will include only cars sold to business customers. You will need to
calculate the profit for each car sold. Show only the make, purchase price, sale price,
date sold, company names and profit, sorted into ascending order of date sold.
Display your name, Centre number and candidate number in the header. Add the title
Cars sold to business customers
Calculate the total profit and display it at the end of the report.
Format all currency values in pounds (sterling) to 2 decimal places.
Save and print this report."

I could not do the "calculating the total profit part"
When I write =Sum([Profit])
It gives an error. Which formula should I use???
This is a CIE 2010 Question.
Can someone help me?
Thanx
(edited 13 years ago)
Reply 1
Avatar for sarpkaya
sarpkaya
OP


and

Reply 2
Avatar for GFI
GFI
Well, I think it is best information and I really like the way of your providing it will help for all needy people.
Reply 3
Avatar for sarpkaya
sarpkaya
OP
Solved it by writing formula to Report Footer instead of Page Footer
(edited 13 years ago)

Related discussions

Latest

Trending

Trending

Articles for you