Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2017
    Posts
    1

    Unanswered: HELP Database questions(MS Access)

    Hi everyone,
    I have 2 questions to solve with MS Access, can anyone please guide me how to solve these, I'll be very thankful. Please fins the attached file for the tables.

    5. Create a report to return the ten most lucrative customers in descending order, which displays their Surname, First Name, Total spent (which is the sum of all their bookings), their last booking date and total number of bookings.

    6. Create a report to provide the total price for a specific booking. The report should take the booking number as input and return the booking number, customer surname, total time, hourly rate and total price of that specific booking. Call the report Booking Invoice.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,102
    Provided Answers: 17
    For Q5, create a query to identify the top 10 customers (hint - SELECT TOP) and then base a report on this query.

    For Q6, create a parameter query that pulls all of the required information together. Then base a report on the query, using whichever levels of grouping and footers you deem necessary to provide the totals.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •