TopQuery.doc (beginner)

Please consider donating $1 per sample downloaded, find out why here. 

TopQuery.doc
Illustrates issues involving the TOP predicate
SQL, the query language of Microsoft Access, has many powerful, yet little known features. One of these is the Top Query. A Top query allows you to limit the results of a query to a certain number (or percentage) of records. 
The term "top" is deceiving, because it implies "largest" values. However, this is not strictly the case. You can choose the top largest values or the top smallest values. As we will see later, you can even choose random records
Document with Sample Databases 
Download
Access 2000+ (259 KB): uploads/5/TopQuery2k.zip 

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Online Status: Offline Posts: 229	Post Options Post Reply Quote Roger Carlson Report Post Quote Reply Topic: TopQuery.doc (beginner) Posted: 17 Jul 2008 at 7:02am
	Please consider donating $1 per sample downloaded, find out why here. TopQuery.doc Illustrates issues involving the TOP predicate SQL, the query language of Microsoft Access, has many powerful, yet little known features. One of these is the Top Query. A Top query allows you to limit the results of a query to a certain number (or percentage) of records. The term "top" is deceiving, because it implies "largest" values. However, this is not strictly the case. You can choose the top largest values or the top smallest values. As we will see later, you can even choose random records Document with Sample Databases Download Access 2000+ (259 KB): uploads/5/TopQuery2k.zip
	Please consider donating $1 per sample downloaded, find out why here.