Is there a maximum number of rows

[Bob Howard]

I developed some software used by someone elsewhere.

According to his information, one of the reports should show roughly 125 or
130 detail lines of print. I implemented a query (specifically for that
report) which groups and sums on various fields.

But mono matter what, the report always shows exactly 100 lines of detail.

There's no VBA code behind the report, and I cannot see anything in the
report that would cut off the data after 100 rows. So now I'm trying to
determine whether it could be the query.

I used Access 2003's "query builder" to create the query ... I don't know
how to build a query "manually".

Thanks.

Bob

 

[John Spencer]

Well, there is a Max Records property that can be set, but that property
applies only to ODBC connections or to MS SQL Server database.

Other than that check to see if the Top Values property of the query is
set to 100 (instead of to 100% or ALL). If the Top Values property of
the query is set to some number or percentage, change the property to ALL.

Or open the query in SQL design view and see if the query starts with
SELECT TOP (someNumber or percent) [Name of field] ...
then delete the word TOP and the number from the SQL statement.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Bob Howard]

I checked the top values on the query's property sheet ... it's set to
"All". I'll need to do a bunch of digging into the application to see if
there's something messed up in my code... Thanks for the help... bob

Well, there is a Max Records property that can be set, but that property
applies only to ODBC connections or to MS SQL Server database.

Other than that check to see if the Top Values property of the query is
set to 100 (instead of to 100% or ALL). If the Top Values property of the
query is set to some number or percentage, change the property to ALL.

Or open the query in SQL design view and see if the query starts with
SELECT TOP (someNumber or percent) [Name of field] ...
then delete the word TOP and the number from the SQL statement.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I developed some software used by someone elsewhere.

According to his information, one of the reports should show roughly 125
or 130 detail lines of print. I implemented a query (specifically for
that report) which groups and sums on various fields.

But mono matter what, the report always shows exactly 100 lines of
detail.

There's no VBA code behind the report, and I cannot see anything in the
report that would cut off the data after 100 rows. So now I'm trying to
determine whether it could be the query.

I used Access 2003's "query builder" to create the query ... I don't know
how to build a query "manually".

Thanks.

Bob