Part 1: Create a query that spans both tables. Part 2: Modify the Query to selec
ID: 3597191 • Letter: P
Question
Part 1: Create a query that spans both tables.
Part 2: Modify the Query to select only those Customers that had service dates in 2 specific months (e.g. Jan & Feb 2007).
Part 3: Create a report that displays the results of your query. This report should list customer information, and under each customer record should list all related customer service records.
Read plug-in T8
Use the Report Wizard
Select an appropriate field for the Grouping parameter in the Report wizard. (This is probably the most challenging part of this assignment). Your goal is that for the listing of each customer record, the associated Customer Service records (i.e. the records from the "Customer (service) Record" table should be listed below it, but only displaying the Service date and Weight fields (not repeating the Customer ID).
Customer records Customer ID First Name Last Name Gender 1009 Kevin Grundies M 1016 Oscar Gomez M 1032 Hillary Flintsteel F 1042 Maria Andretti F 1119 Sharad Manispour M 1173 Roberta Kurzweil F 1355 Barbara Grabowski F 1441 James Van Horn M 1614 Artie Lambros M 1851 Melinda English F 2002 Edgar Rothrock M 2042 Hillary Cushner F 2105 Luca Pacioli M 2122 Yuan Chang M 2344 Nemesha Mehta F 2451 Francine Detweiler F 2678 Koshi Yamamoto F 2733 John Zumkowski M 2768 Phyllis Leonard F 2896 Samuel Gates M 2956 Michael Goldstein M 3015 Patti Stonesifer F 3117 Frederich Bednarczyk M 3210 Carmen Ortega-Molina F 3314 Svetlana Kartashev F 4006 Alice Rovik M 4123 Steve Ballmer M 7577 Mohammed Mohammed M 8888 Kylie Walker FExplanation / Answer
Part1:-
This query will retrieve all the records from both the tables
Part2:-
This query will retrieve all the records of customer and customer service records which are having the month of service date Jan and Feb only
.
Part 3:-
The above will prints all the customer and customer service information according to the customer id