I need help writing the Queries for Case 4 in the Problem Solving Cases in Micro
ID: 3756428 • Letter: I
Question
I need help writing the Queries for Case 4 in the Problem Solving Cases in Microsoft Access in Excel 13th Edition. Write a Query that calculates the amount of money each boat owner earns from rentals.
Money Earned: ([End Date]-[Start Date])*[Price Per Day]
Thats what I have, but I am recieving a blank table.
Query Tools RobertsBoatRentals: Database- Usersis5 cdb (Access 2007- 2016 file format)-Access reate External Data Database Tools 0 Tell me what you want to do.. File Design CD Union Insert Columns Insert Rows X Delete Rows Delete Columns Property Shect Pass-Through Data Defition Table Table Names View Run Select Make Append Update Crosstab Delete Show Totals Parameters Return:|All Table Builder Results Query Type Query Setup All Access Obje...uePower Bosts by Length Money Earned by Owners Owners Table Rentals Table Tables Boat Table Owners Table Rentals Table Renters Table owner ID Last Name First Name Boat ID Renter ID Start Date End Date Boat Table City Queries Boat ID Money Eamed by Owners Power Boats by Length Renters Not Qualified Lower Boat Prices Boat Type Size Descnption Owner ID Field: Address Table: Owners Table City Owners Table State Owners Table Start Date Rentals Table End Date Rentals Table Price Per Day Boat Table teD Price Per Day Owners Table Sort: Show Criteria Form View 413 PM /28/2018Explanation / Answer
Please find the query below.
Query:
SELECT o.LastName, o.FirstName, o.Address, o.City, o.State, o.Zip, sum(DateDiff("d", r.EndDate, r.StartDate)*b.PricePerDay) AS MoneyEarned FROM Owners o, Boat b, Rentals r
WHERE b.OwnerID = o.OwnerID AND r.BoatID = b.BoatID GROUP BY b.OwnerID;