I need to create a query for this access report. The description needs to include the work "trek" and the cost per hour needs to be greater than $12. I am not sure how to proceed with this. The data needs to be viewed by the customer. This is what I have-

And this is what I need it to look like-

Any help would be appreciated. Please put it in leymans terms if possible

Report Design Tools Bryan Rockwel MS Access Assginment Part 2 and 3: Database-Wvmware-ho Sign in ? X - a Restore External DataDatabase Tools Design Arrange Format Page Setup Tell me what you want to do Move Size 2Subreport in New Window Logo D Title Date and Time Totals - Minimize Group & Sort Page Numbers Hide Details Add Existing Property Tab Maximize Fields'Sheet. Convert Report's Macros to Visual Basic Tools Image" Order x Close Grouping&Totals Controls Header Footer CUSTOMER Query 4 Report Search.. Report Header Tables BIKE CUSTOMER RENTAL Rockwell303 Customer Rental Report Page Header Fist Nest NaraeBeslinionRenta at Per Hou First Name State First Name Header 1 All Tables and Data 2 Bike Under S15 3 Specialized Customer 1 4 Customized Customers 2 5 Customers Damage 6 Bike Count 8 My Query 7Update Query First Name Last Name Description Cost Per Hour Date Detail Page Footer NowO "Page" & [Page] &" of "&[Pages Report Footer Reports CUSTOMER Query 4 Report Design View 8 53 PM Type here to search di) 11/11/2017 ^