Access 97 Articles Available by Fax or E-Mail: Queries

• Microsoft Access 97

SUMMARY

This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail or by fax. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.

MORE INFORMATION

The "Article Listing" section of this article includes a subset of Knowledge Base articles about Queries in Microsoft Access 97. Use the instructions in the "Ordering an Article by E-Mail or by Fax" section of this article to order items from this list.

Note that because Microsoft Technical Support is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Technical Support on the Web is located at the following address on the World Wide Web:

   http://support.microsoft.com/support/default.asp

ORDERING AN ARTICLE BY E-MAIL OR BY FAX

Ordering an Article by E-Mail

To have an article from the list sent to you in e-mail, send a message to "mshelp@microsoft.com" (without the quotation marks), and use the Article ID in the subject line of the message, as in the following example:

     TO: mshelp@microsoft.com
     SUBJECT: Q119591

   mshelp@microsoft.com

Ordering an Article over the Phone and Having It Sent to a Fax Machine

To have an article sent to a fax machine, use the Microsoft FastTips System. Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this article list, first note the five- to six-digit number of the Article ID shown for each item, and then follow these steps:

1. Dial the toll-free FastTips number:

         (800) 936-4100
   

2. When prompted, select the appropriate number for the product you are using (for example, for Microsoft Word, select 2).

3. When prompted, select the version of the product that you are using.

4. From the "FastTips Main Menu," select 1 to place a FastTips catalog order.

5. At the "to order items from your catalog" prompt, select 1.

6. When prompted with the "at the tone, enter the item ID number followed by the pound key" message, enter the Article ID number from the following list and press # (use the numbers following "Q," but do not include "Q").

         NOTE: You can order up to five items at a time.
   

7. When prompted, select the fax option and enter your three-digit area code and seven-digit fax number.

8. When you're finished ordering, hang up.

ARTICLE LISTING

 ITEM ID  ARTICLE TITLE                                               PAGES
 --------------------------------------------------------------------------

 Q90809  ACC: How to Use a Query to Filter Unique Data                    2
 Q91710  ACC: "Can't Bind Name '[XXX]'" Error with Crosstab Query         3
 Q93690  ACC: How to Update a Table Based on Values in a Second Table     2
 Q95608  ACC: How to Parse Comma-Separated Text into Multiple Fields      4
 Q95931  ACC: How to Use the Query-by-Form (QBF) Technique                4

 Q98664  ACC: Deleting Duplicate Records from Two Tables                  3
 Q99321  ACC: Tips for Optimizing Queries on Attached SQL Tables          3
 Q100135 ACC: How to Search for Characters or Strings in Records          4
 Q101081 ACC: Referring to a Field in the Previous or Next Record         6
 Q103269 ACC: Updating a Table from a Second Table Using an Expression    2

 Q109329 ACC: How to Delete Duplicate Records from a Table                2
 Q112108 ACC: How to Create an SQL Pass-Through Query in Code             3
 Q112112 ACC: How to Optimize Queries in MS Access v. 2.0, 95, and 97     7
 Q131534 ACC: How to Simulate Parameters in an SQL Pass-Through Query     4
 Q136062 ACC: Query by Form (QBF) Using Dynamic QueryDef (95/97)          5

 Q138911 ACC: How to Create Running Totals in a Query (95/97)             5
 Q154600 ACC: How to Parse Titles Beginning with "A," "An," or "The"      2
 Q159731 ACC97: Why a Calculated Control Is Blank                         1
 Q161329 ACC97: Error: "There Isn't Enough Disk Space or Memory"          5
 Q161861 ACC97: "Can't Represent the Join Expression" in Query Design     5

 Q162977 ACC97: ASP Query Cannot Be Used with the LIKE Predicate          5
 Q163443 ACC97: Action Queries Cannot Be Exported to HTML, IDC, or ASP    5
 Q163536 ACC97: Doc Error: Cannot Export Queries or Macros from 97 to 95  2
 Q163703 ACC: RecordsAffected Property Incorrect for SQL Pass-Through     4
 Q163943 ACC97: IPF in Msjet35.dll Running Update Against Attached Table  5

 Q164239 ACC97: InputBox Error: "Function Isn't Available in Expressions" 4
 Q164481 ACC97: Tips for Converting Applications to Using ODBCDirect     10
 Q165035 ACC: Combo Box Wizard Doesn't Display Third Option w/SQL Stmt    2
 Q165272 ACC: Error Message "Can't open any more tables"                  3
 Q165823 ACC: Database Grows Rapidly When You Modify SQL Statements       4

 Q166634 ACC97: Filter-by-Form Example for Run-Time Apps Available on MSL 2
 Q167851 ACC97: Canceling Parameter Prompt Stops Publish To Web Wizard    3
 Q168438 ACC97: Changes with DISTINCTROW in Microsoft Access 97           4
 Q168870 ACC97: Can't Export to Text with File Name Greater Than 60 Char  3
 Q168874 ACC97: Publish to the Web Wizard Fails on SQL Specific Query     3

 Q170218 ACC97: SQL Memo Fields Truncated to 255 in Update Query          3
 Q174341 ACC97: Failed Append Query Causes Bloat in Multi-User Database   4