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
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