Answered step by step
Verified Expert Solution
Question
1 Approved Answer
We would like to create another PivotTable to show the breakdown by Expense Category, but we do not currently have Expense Category in our query.
We would like to create another PivotTable to show the breakdown by Expense Category, but we do not currently have Expense Category in our query. Have a look at the query list and you will see a query called ExpenseCodes which gives us the Expense Code and Category. Modify the Expenses query so it includes another column that gets the matching Category for each Expense Code. Which combine query option did you need to use?
point
Left Outer Join
Left AntiJoin
Right AntiJoin
Full Outer Join
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started