ACC97: Microsoft Access 97 Sample Queries Available in Download Center
ID: Q182568
|
The information in this article applies to:
SUMMARY
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. Click the file name below to download the file:
Qrysmp97.exe
The Qrysmp97.exe file contains the following files:
Qrysmp97.mdb The queries sample database.
Readme.txt This information in text format.
For more information about how to download files from the Microsoft
Download Center, please visit the Download Center at the following Web
address
http://www.microsoft.com/downloads/search.asp
and then click How to use the Microsoft Download Center.
Additional query words:
example how to
Keywords : kbdta QryHowto Softlib
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbhowto