Qualification > Miscellaneous
Official Thread for AICT Doubts !
Mike Benn:
--- Quote from: Mike Benn on October 04, 2011, 06:07:39 pm ---HELP REQUIRED >>>>> MAY JUNE 2009
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.".
--- End quote ---
NotAbod:
DO not double post please.
either post here, or start a thread.
Posting here is better.
Mike Benn:
--- Quote from: Abod on October 04, 2011, 06:11:54 pm ---DO not double post please.
either post here, or start a thread.
Posting here is better.
--- End quote ---
ok . em sorry.. By the way i use MS 2003 .., how to get this task done. it's 21 marks
NotAbod:
Give me 30-45 minutes, i will solve and post the steps here.
and check your private messages. ;)
Mike Benn:
--- Quote from: Abod on October 04, 2011, 06:15:25 pm ---Give me 30-45 minutes, i will solve and post the steps here.
and check your private messages. ;)
--- End quote ---
Sure..:P
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version