ACC97: RecordSource Property Syntax Incorrect in Access 97 Help

ID: Q161031

The information in this article applies to:

Microsoft Access 97

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 :