ACC97: Report Based on Query Has More Records Than the Query

• You create a report based on a query to an ODBC data source.
  
  -and-
• The MaxRecords property is set for that query.

Back to the top

Steps to Reproduce Problem

1. Create a data source to the SQL Server Pubs database.
2. On the File menu, point to Get External Data, and then click Link Tables.
3. In the File Of Type list, click ODBC Databases. Click Link
4. Select the data source created in step 1. Click OK.
5. Click dbo.authors, and then click OK.
6. 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
   						

7. Set the MaxRecords property of the query to five.
8. On the Query menu, click Run.
   
   Notice that the result contains only five records.
9. Click the qryAuthors query. On the Insert menu, click AutoReport.
   
   Notice that the report contains all records, not just the first five.

Back to the top