October 20, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Visual Basic Database Tutorial - Part 3

  • November 19, 2002
  • By Karl Moore
  • Send Email »
  • More Articles »

OK, so you've produced that list of customers - and now your boss wants them in alphabetical order. Argh! Don't you just want to murder picky users?

Still, once again, Microsoft Access can help out.

Change the query we created in the last section to look like the below. I've simply removed the "France restauration" criterion and changed the "Sort" box to "Ascending"

Now run the query by entering into Datasheet View. You should find that all the companies are now listed in alphabetical order.

The SQL statement for this looks like:

SELECT Customers.CompanyName, Customers.ContactName
FROM Customers
ORDER BY Customers.CompanyName;

You can even reverse that order by changing 'Ascending' to 'Descending'.





Page 4 of 10



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel