How many different kinds of inventory items does S&S sell?
Query
Query Result
How many sales were made during October?
Query
Query Result
. What were total sales in October?
Query
Query Result
d. What was the average amount of a sales transaction?
This question requires the use of a total invoice calculation, thus, a total invoice table is prepared as a Microsoft “Make Table Query” in Microsoft Office. A Make Table Query is prepared the same as a normal query except that the user selects the Make Table Query option in the Query Type portion of the Query Design Tools ribbon.
Make Table Query
Table Result
Query
Query Result
Share with your friends: | 
