Create a make table query named Customer_Age that calculates the average ageof customers who have stayed at each hotel. Store the results in a new table name Ananlytical_Customer Age. The top section of the table should look like figure 8-6 (above)

I need help with the formula to ge these result this is what I currently have...

I keep getting these huge numbers.

156 Case 8 Analytical Customer Age Room Hotel Name " Avenue of the Arts Callowhill Chinatown Elfreth's Alley Fitler Square French Quarter Jewelers' Row Age 29.8 29.4 30.6 29.3 30.5 29.3 30.8 FIGURE 8-6 Analytical_Customer_Age table Query Tools Boutique: Database- ClUsersjlbennO DesktoplBoutique.accdb (Access 2007- 2016 file format) - Access Create External Data Database Tools Design Ascending File Homc Tell me what you want to do.. Sign in Cut Ea Copy Selection 0tals c Replace -1 New Descending Advanced Hsave wjSpelling View Paste Filter Remove Sort Toggle Fiter All-XleMor Format Painter Delete Select Views Clipboard Sort & Filter Records Find Text Formatting Custonier-Age(H Analytical-Customers All Access Obje... Property Sheet Seorch.. Analytical Customers Analytical RoomsReser Selection type: Field Properties Tables General Lookup 1 Reservation JD Analytical Country Gender Analytical-customers Analytical-Reservations Analytical_Rooms Analytical-RoomsReserved customer ID Description Format Decimal Places nout Mask Ception Room ID Fired Customer First Na Customer Last Customer Email A Customer, Gender Analytical Rooms Room ID nalytical Reservations Analytical Country GenderQ Analytical-capacity,Gnd Customer Age Reservations Summany Room Capacity Room Pets Allowed Room Smoking Allo Room Hotel Name | 3 Rescrvation ID Reservation Start Reservation Length Customer ID Field: Room Hotel Name Age: Customer DOB Table: Analytical Rooms Analytica Total: Group By Sort: Show Avg Criteria: Ready Num Lock901 9:30 AM 3/1/2019 Boutique: Database- CUsers'jlbenn0ADesktop Boutique.accdb (Access 2007- 2016 file format) - Access File Homc Create External Data Database Tools Tell me what you want to do.. Cut E Copy 2l Ascending Selection NewTotals Descending Advanced- ^E, save wjSpelling Remove Sort Toggle Fiter AlXMore Go To View Paste Filter Refresh Find Format Painter Delete Clipboard Sort & Filter Records Find Text Formatting A paste (Ctrl-je Customer-Age All Paste (Ctri-V) ()