ACC97: Report Based on Query Has More Records Than the Query
ID: Q192031
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you print or preview a report that is based on a query, it may contain
more records than the query returns.
CAUSE
You may encounter this problem when the following conditions are true:
- You create a report based on a query to an ODBC data source.
-and-
- The MaxRecords property is set for that query.
Queries based on ODBC tables (such as Linked SQL Server tables) can use the
MaxRecords property to limit the number of records that are returned from
the ODBC data source. However, when you create a report based on a query
that has the MaxRecords property set, the report ignores the MaxRecords
property and returns all the rows from the data source.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
MORE INFORMATION
Steps to Reproduce Problem
- Create a data source to the SQL Server Pubs database.
- On the File menu, point to Get External Data, and then click
Link Tables.
- In the File Of Type list, click ODBC Databases. Click Link
- Select the data source created in step 1. Click OK.
- Click dbo.authors, and then click OK.
- Create the following query:
Query: qryAuthors
---------------------------
Type: Select Query
Field: Last Name: au_lname
Table: dbo_authors
Sort: Ascending
Field: First Name: au_fname
Table: dbo_authors
- Set the MaxRecords property of the query to five.
- On the Query menu, click Run.
Notice that the result contains only five records.
- Click the qryAuthors query. On the Insert menu, click AutoReport.
Notice that the report contains all records, not just the first five.
REFERENCES
For more information about the MaxRecords property, search on "maxrecords
property," using the Microsoft Access Help Index.
Keywords : kbdta RptProb
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug