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

Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: Adzel on March 29, 2010, 12:43:44 pm

Title: ICT Help please....
Post by: Adzel on March 29, 2010, 12:43:44 pm
I want to know how to do this question please...

0418/02
Paper 2 Practical Test October/November 2008

15 Produce a new report from all the data which:
shows only the records which contain the word decaffeinated in the Notes field <=====
• has a page orientation of portrait
• shows only the fields Code, Product, Price and Stock
• is sorted into descending order of Code

As Soon As Pssible......Thanks
Title: Re: ICT Help please....
Post by: BlackBunny103 on March 29, 2010, 02:10:23 pm
Hello
In the querry, under the criteria for Notes type in decaffeinated*
Title: Re: ICT Help please....
Post by: Adzel on March 29, 2010, 03:07:02 pm
thanx Black.
Title: Re: ICT Help please....
Post by: BlackBunny103 on March 31, 2010, 02:24:55 pm
No prob. Hope it helps  :D
Title: Re: ICT Help please....
Post by: asdf123 on April 02, 2010, 04:44:22 am
its not decaffeinated* its *decaffeinated* star at both ends
Title: Re: ICT Help please....
Post by: 7ooD on April 02, 2010, 10:54:06 am
thx so much asdf
Title: Re: ICT Help please....
Post by: Vin on April 06, 2010, 02:53:52 pm
summary is basically creating a query wherein u jus havta mak a query followed by a report... it is usually export it to 'rtf'(for importing in a text document/ preferably exported from a report) or excel (.xlsx  for graph or charting package / suitably from a query)..
post a ques frm a past paper fo instance...because it always depends on the question....hopefully i'd b ab;e 2 answer tht... :)
Title: Re: ICT Help please....
Post by: °o.O-hash94-O.o° on April 06, 2010, 07:48:25 pm
please use this thread for ICT doubts!

https://studentforums.biz/index.php/topic,6544.0.html (https://studentforums.biz/index.php/topic,6544.0.html)
Title: Re: ICT Help please....
Post by: Monica on April 06, 2010, 11:34:49 pm
please use this thread for ICT doubts!

https://studentforums.biz/index.php/topic,6544.0.html (https://studentforums.biz/index.php/topic,6544.0.html)

You can merge this thread with the "ICT doubts" thread now.