Author Topic: ICT doubt.....pl help ASAP  (Read 2823 times)

Offline JasirulQadir

  • Newbie
  • *
  • Posts: 2
  • Reputation: 14
ICT doubt.....pl help ASAP
« 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
and the marking scheme: http://www.xtremepapers.com/CIE/Cambridge%20IGCSE/0417%20-%20Information%20And%20Communication%20Technology/0417_w09_ms_2.pdf

pl help   :)

Offline Flamed-Ghoust

  • I would love to help, but.....you know
  • SF Citizen
  • ***
  • Posts: 191
  • Reputation: 65535
  • Gender: Male
Re: ICT doubt.....pl help ASAP
« Reply #1 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.
I can only please one person a day
Today is NOT your day and tomorrow doesn't look good either

Offline JasirulQadir

  • Newbie
  • *
  • Posts: 2
  • Reputation: 14
Re: ICT doubt.....pl help ASAP
« Reply #2 on: April 03, 2012, 07:44:46 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!

Offline Flamed-Ghoust

  • I would love to help, but.....you know
  • SF Citizen
  • ***
  • Posts: 191
  • Reputation: 65535
  • Gender: Male
Re: ICT doubt.....pl help ASAP
« Reply #3 on: April 04, 2012, 08:31:50 am »
roger
I can only please one person a day
Today is NOT your day and tomorrow doesn't look good either

Offline Flamed-Ghoust

  • I would love to help, but.....you know
  • SF Citizen
  • ***
  • Posts: 191
  • Reputation: 65535
  • Gender: Male
Re: ICT doubt.....pl help ASAP
« Reply #4 on: April 09, 2012, 09:49:39 am »
use the formulas

Fx will help you
I can only please one person a day
Today is NOT your day and tomorrow doesn't look good either

Offline dudu

  • Newbie
  • *
  • Posts: 1
  • Reputation: 11
Re: ICT doubt.....pl help ASAP
« Reply #5 on: April 22, 2012, 08:16:58 am »
Same Problem. Somebody help please?

Offline Centrino

  • Newbie
  • *
  • Posts: 8
  • Reputation: 25838
Re: ICT doubt.....pl help ASAP
« Reply #6 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