The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
a.Dim records =
From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order invoice.CustomerNum Ascending
Select customer
b.Dim records =
From CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order invoice.CustomerNum
Select customer
c.Dim records =
From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order By invoice.CustomerNum
Select customer
d.Dim records =
From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt < 200
Order By invoice.CustomerNum
Select customer
