ACC97: Microsoft Access 97 Sample Queries Available in Download Center

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q182568

Moderate: Requires basic macro, coding, and interoperability skills.

Expand all | Collapse all

SUMMARY

The Qrysmp97.exe file contains a sample database with over 20 query examples. These examples demonstrate how to create many types of queries, including select queries, crosstab queries, totals queries, and SQL pass-through queries. Topics include using a subquery as criteria, referring to a field in the previous or next record, creating a union query, ranking records, creating a SQL pass-through query in code, grouping column headings in a crosstab query, and many more.

The following file is available for download from the Microsoft Download Center:

Qrysmp97.exe (http://download.microsoft.com/download/access97/samp/1/win98/en-us/qrysmp97.exe)

The Qrysmp97.exe file contains the following files:

   Qrysmp97.mdb   The queries sample database.
   Readme.txt     This information in text format.

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 (http://support.microsoft.com/kb/119591/EN-US/ ) How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

APPLIES TO

Microsoft Access 97 Standard Edition

Back to the top

kbdownload kbhowto KB182568

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top