ACC97: RecordSource Property Syntax Incorrect in Access 97 Help

ID: Q161031

The information in this article applies to:

SYMPTOMS


SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

The "RecordSource Property" topic in the Microsoft Access 97 Help system contains a syntax error. The example in the "Sample setting" section of the Help topic reads as follows: 


   SELECT Orders!OrderDate FROM Orders;

This is incorrect.

The correct syntax for this example is: 

   SELECT Orders.OrderDate FROM Orders;

Note that the correct syntax uses a period (.) after "Orders" instead of an exclamation point (!). 


Keywords          : QrySqlvw 
Version           : 97
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 30, 1999