Windows 8 
Access 2013
ItemsWithMultipleSuppliersQuery:
This query should display items that are supplied by more than one
supplier. This query should return the following fields: ItemID, ItemDescription, and the count of
SupplierIDs for each ItemID. You will be required to use the Totals functionality of your query. When you
have selected your fields for the query, click on the Σ symbol under the design tab. For each field you wish
to summarize select the summary operation (count, sum, etc.) from the Total row. Leave all others as
“Group By.”
Is that correct?
Reply With Quote
