Chapter 40: Making Queries Work Together
4040
FIGURE 40.2
Merge the Last_Name and First_Name columns to create a new Employee field.FIGURE 40.3
Group the Employee field and sum the Sales Amount column to create a new Revenue
column.So, what if you wanted to create another analysis using the same data? For
instance, what if you wanted another view that shows employee sales by business
segment?