• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

plz help

Messages
97
Reaction score
84
Points
28
I'm an ICT student in AS
I have a problem in the paper 2009 m/j p2 question 10
here is the question
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. Place your name,
Centre number and candidate number in the header of your report.

should i use query design or query wizard
iif you have solution to the question please answer me
thanksss
 
Top