Question ID: 6579 1/22
NEXT QUESTION

Create a query named q1 deriving data from the Customers and Rents tables. The query will export the following fields in the following order: CSurname, CName and Date1. Sort the three fields in ascending order. Then apply a criterion to the Date field to retrieve the records of a date greater than or equal to 8/1/2004

 

 

Other versions
OpenOffice.org Base 3.3LibreOffice Base 4.0

 

 

 


Create a query named q1 deriving data from the Customers and Rents tables. The query will export the following fields in the following order: CSurname, CName and Date1. Sort the three fields in ascending order. Then apply a criterion to the Date field to retrieve the records of a date greater than or equal to 8/1/2004