IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: JasirulQadir on March 29, 2012, 08:56:41 pm

Title: ICT doubt.....pl help ASAP
Post by: JasirulQadir on March 29, 2012, 08:56:41 pm

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 (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 (http://www.xtremepapers.com/CIE/Cambridge%20IGCSE/0417%20-%20Information%20And%20Communication%20Technology/0417_w09_ms_2.pdf)

pl help   :)

Title: Re: ICT doubt.....pl help ASAP
Post by: 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.

Title: Re: ICT doubt.....pl help ASAP
Post by: JasirulQadir on April 03, 2012, 07:44:46 pm

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.

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!

Title: Re: ICT doubt.....pl help ASAP
Post by: Flamed-Ghoust on April 04, 2012, 08:31:50 am

roger

Title: Re: ICT doubt.....pl help ASAP
Post by: Flamed-Ghoust on April 09, 2012, 09:49:39 am

use the formulas

Fx will help you

Title: Re: ICT doubt.....pl help ASAP
Post by: dudu on April 22, 2012, 08:16:58 am

Same Problem. Somebody help please?

Title: Re: ICT doubt.....pl help ASAP
Post by: Centrino on May 17, 2013, 12:20:31 pm

OK, so this one's really old but I'm still going to write my answer for future reference.

1. Open the Query Wizard.
2. Select only the fields 'Staff' and 'Number'.
3. Click 'Next' and select 'Summary' from the options provided.
4. Click on 'Summary options', this will open a small window.
5. In this case, click on the 'Sum' radio box and the 'Count records in N9Book' on the bottom right of the window. Click OK.
6. Go through the rest of the wizard as you'd normally do.
7. Create a report using this query.

Et voila! :D