Qualification > Miscellaneous

ICT doubt.....pl help ASAP

(1/2) > >>

JasirulQadir:
Hello!
MAy Peace be upon you!
i cant do a step in ICT 2009 o/n paper 2

46. Produce a new report from all the data which:
• uses only the Staff and Number fields
• calculates the sum of the Number field for each member of Staff
• counts the number of holidays sold by each member of Staff

this is the link to the paper: http://www.xtremepapers.com/CIE/Cambridge%20IGCSE/0417%20-%20Information%20And%20Communication%20Technology/0417_w09_qp_2.pdf
and the marking scheme: http://www.xtremepapers.com/CIE/Cambridge%20IGCSE/0417%20-%20Information%20And%20Communication%20Technology/0417_w09_ms_2.pdf

pl help   :)

Flamed-Ghoust:
this is one of the meanest questions and they will come a lot.


Now when u want to produce a report you have to produce a query nd as far as i remember you should use the query design and then the report.
Any way that's just a skim of what you have to do.
tomorrow i will be at school and i will do that question for you and give you the answer in details.

JasirulQadir:

--- Quote from: Flamed-Ghoust on April 02, 2012, 02:29:06 pm ---this is one of the meanest questions and they will come a lot.


Now when u want to produce a report you have to produce a query nd as far as i remember you should use the query design and then the report.
Any way that's just a skim of what you have to do.
tomorrow i will be at school and i will do that question for you and give you the answer in details.

--- End quote ---

Thank You
but i know how to make a normal report, this report is a bit strange
i have no idea how to calculate the sum for EACH member of staff!

Flamed-Ghoust:
roger

Flamed-Ghoust:
use the formulas

Fx will help you

Navigation

[0] Message Index

[#] Next page