Share this Page URL

Chapter 6. Sorting, Filtering, and Retri... > Designing Select Queries - Pg. 211

Sorting, Filtering, and Retrieving Data 211 4. 5. On the File menu, click Save, and then name this query qryExpenseReport. From the field list for the MarketingCampaigns table, add CampaignID, Country, and Cam- paignBudget to the query design grid. From the CampaignExpenses table, add ExpenseType, AmountSpent, and DatePurchased. The Query window will look like this: