Question: Create a make table query named Customer_Age that calculates the average age of customers who have stayed at each hotel. Store the results in a

Create a make table query named Customer_Age that calculates the average age of customers who have stayed at each hotel. Store the results in a new table named Analytical_Customer_Age. The top section of the table should look like Figure 8-6

Create a make table query named Customer_Age that

I have tried the date differential , the Date Serial the Date() formats none of them work ...

This is in Access btw

Analytical Customer Age Room_Hotel_Name Age Avenue of the Arts 29.8 Callowhill 29.4 Chinatown 30.6 Elfreth's Alley 29.3 Fitler Square 30.5 French Quarter 29.3 Jewelers' Row 30.8 FIGURE 8-6 Analytical_Customer_Age table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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

Exp19_Access_Ch06_Capstone - Northwind Traders Sales Analysis 1.0 Project Description: Northwind Traders is a small international gourmet foods wholesaler. You will update the companys database by...

Project Description: Northwind Traders is a small international gourmet foods wholesaler. You will update the company's database by increasing the price of all of the meat and poultry products. You...

E 1. Create a new table in datasheet view, using the Table tool on the Create ribbon. 2. Rename the first field as Venuels with the data type Short Text. Add the caption Venue ID. 3. Add each of the...

Dr. Jenny Brown is the new CEO of a hotel chain, Hassle Free Hotel. The hotels headquarter is based in Atlanta, Georgia in the U.S. The company was established in 2004. It has a central reservation...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

4. (12 points) LGS Investment's database contains all of the information on the properties the firm has listed and sold. You are a manger with this firm and want to use the database to determine the...

Read the attached article and answer the following questions in report format: Discuss the factors that drove Harrah's customer relationship strategy. Discuss whether Harrah's business and IT...

Harrah's High Payoff from Customer Information Introduction Harrah's Entertainment, Inc. (or simply Harrah's) is assuming a leadership role in the gaming industry through a business strategy that...

SQL Assignment ACCTG 333 - Fall 2021 (Professor Perols) Why should you learn SQL? Technology is drastically changing the accounting industry...and structured query language (SQL) is one of the...

(a) Let f: C C be differentiable at zo. Considering f as a map R? R?, that f'(zo) = kR where k is a non-negative constant, and R is a 2 x 2 rotation matrix; that is, a matrix of the form prove...

How does the IRS decide on the percentage of income tax returns to audit for each state? Suppose they do it by randomly selecting 50 values from a normal distribution with a mean equal to 1.55% and a...

1. A line drawn at 90 to a surface is called: (a) an incident (b) a normal (c) a reflection (d) a mirror

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...