Article ID: 182568 - View products that this article applies to.
This article was previously published under Q182568
Moderate: Requires basic macro, coding, and interoperability skills.
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.exeThe Qrysmp97.exe file contains the following files:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
Qrysmp97.mdb The queries sample database. Readme.txt This information in text format.
119591Microsoft 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.
(https://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
Article ID: 182568 - Last Review: January 22, 2007 - Revision: 4.3
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.