asked 213k views
1 vote
If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

1 Answer

5 votes

Answer:

from the highest to lowest Price

Step-by-step explanation:

Design grid is useful in adding fields to the query. And a query can be described as SQL statement which removes rows that matches the criteria which has been specified from one or more tables.

Examples of query are

* Parameter query.... This allows the creation of a query that can be updated easily to reflect a new criterion

* Find duplicate query....... This helps to find all duplicate records in your database so you can delete them.

In this case, the datasheet which is showing the specification, i.e the list records, will show the price from the highest to lowest.

answered
User Ricardo Mutti
by
8.3k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.