Author Topic: May June 2009,.. Help me out,..  (Read 2079 times)

Offline Mike Benn

  • Newbie
  • *
  • Posts: 44
  • Reputation: 8637
  • Gender: Male
May June 2009,.. Help me out,..
« on: October 04, 2011, 06:05:29 pm »
How do I do task 10
"Select from all the records only the customers that have booked more than one
holiday. Calculate for each of these customers the average price of their holidays.
Include within the report only the Forename, Surname and the summary data.
Group this data by the number of holidays booked. Sort the data within each group into
ascending order of Surname, then into ascending order of Forename. For each group
show the number of customers and the average cost of the holidays. Make sure that
the average costs are formatted into the same currency format as the cost field.
Add the title Customers with more than one holiday to the report. Make sure that the
report fits on a single page and that all data and labels are visible."

Offline NotAbod

  • Wikipedia Contributor
  • Global Moderator
  • SF Farseer
  • *****
  • Posts: 3929
  • Reputation: 65535
  • Gender: Male
Re: May June 2009,.. Help me out,..
« Reply #1 on: October 04, 2011, 06:08:00 pm »
DO mention the subject name, paper number and board (CIE or EDEXCEL)


https://studentforums.biz/information-and-technology/official-thread-for-aict-doubts-!/15/?topicseen

If you've started a thread, then no need to post there.
« Last Edit: October 04, 2011, 06:10:08 pm by Abod »

Offline Mike Benn

  • Newbie
  • *
  • Posts: 44
  • Reputation: 8637
  • Gender: Male
Re: May June 2009,.. Help me out,..
« Reply #2 on: October 04, 2011, 06:11:37 pm »
DO mention the subject name, paper number and board (CIE or EDEXCEL)


https://studentforums.biz/information-and-technology/official-thread-for-aict-doubts-!/15/?topicseen

If you've started a thread, then no need to post there.
Em really very sorry,. it's CIE By the way. and will look for it in the future,. Sorry Sir

Offline NotAbod

  • Wikipedia Contributor
  • Global Moderator
  • SF Farseer
  • *****
  • Posts: 3929
  • Reputation: 65535
  • Gender: Male
Re: May June 2009,.. Help me out,..
« Reply #3 on: October 04, 2011, 06:13:20 pm »
Its okay.

Discuss your doubts Here

Locked.