Question

To display only orders made between 7/1/2018 and 12/31/2018, you should add the OrderDate field and criteria to filter the results. What should you change the Total row to in the query? a) Sum b) Count c) Average d) Where

Answer 1

To show orders between specific dates in a query, you set the Total row to 'Where' and add criteria to the OrderDate field to filter the results accordingly.

Step-by-step explanation:

To display only orders made between 7/1/2018 and 12/31/2018 in a query, you would indeed want to add the OrderDate field as a criterion to filter your results. However, when specifying the range of dates, you wouldn't use aggregate functions like Sum, Count, or Average. Instead, you should change the Total row to 'Where'. By setting it to 'Where', you instruct the database to filter the results based on the specified criteria in the OrderDate field—only including records with dates between 7/1/2018 and 12/31/2018.

Answer 2

In a query to display orders between 7/1/2018 and 12/31/2018, you'd add the OrderDate field and set the criteria as 'Between #7/1/2018# and #12/31/2018#'. The Total row in the query should be set to 'Where', to filter records based on the specified date range.

Step-by-step explanation:

To filter and display only the orders made between 7/1/2018 and 12/31/2018 in a query, you would add the OrderDate field to the query design. Then, you would set specific criteria to include only the dates within this range. In the query's design view, under the OrderDate field, you would enter the criteria as follows: 'Between #7/1/2018# and #12/31/2018#'. This instructs the database to return only the records where the OrderDate falls within the specified range.

When defining what to change the Total row to in the query, the correct choice is 'd) Where'. The Where condition is used to specify which records are to be included in the query result set based on the criteria you have defined. The options such as Sum, Count, or Average are aggregate functions used to perform calculations on a set of values, which is not what is required in this context.