Hi ,tommorow is my exam and i really need the help in S07 QP2 Question 46 :-
Link to the Past Paper :
http://www.xtremepapers.net/CIE/Cambrid … 7_qp_2.pdf
Question itself :
46) Produce a new report from all the data which:-
• shows a summary of only the Staff and Sales fields
• performs a count of the number of sales made by each member of Staff
• calculates the sum of the Sales for each member of staff.
I want to know about all the three points and how to do them ,Please answer before it's too late ,thanks .