Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Bugs: Report returns more records than query

Author(s)
Dev Ashish
  If you're using an ODBC data source in a query which is the source for a report, then the report might have more records than returned by the query.

  This happens when you set the MaxRecords property for the query.   While the ODBC data sources follow this property, a report based on such a query ignores the setting and returns all the records.

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


© 1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer