Question ID: 2021 1/24
NEXT QUESTION

Create a query named q1 to derive data from the Customers and Rents tables. The query will export the following fields in the following order: Surname, FirstName and RentDate. Sort the three fields in ascending order. Then apply a criterion to the RentDate field to retrieve the records of a date greater than or equal to 01/08/2004.

 

 

Other versions
Microsoft Access 2003Microsoft Access 2007Microsoft Access 2010Microsoft Access 2013Microsoft Access 2016Microsoft Access 365

 

 

 


Create a query named q1 to derive data from the Customers and Rents tables. The query will export the following fields in the following order: Surname, FirstName and RentDate. Sort the three fields in ascending order. Then apply a criterion to the RentDate field to retrieve the records of a date greater than or equal to 01/08/2004.