Group Headers in Reports

[Michael]

I am asking this question again, but rephrasing the question to make it more
understandable.

Does anyone know how many records Access 97 (or any version) will group?
There seems to be a limit. For example, if a City field is being used to
group a report and there are 900 cities, Access will group only so many
before it stops grouping.

 

[Rick Brandt]

I am asking this question again, but rephrasing the question to make
it more understandable.

Does anyone know how many records Access 97 (or any version) will
group? There seems to be a limit. For example, if a City field is
being used to group a report and there are 900 cities, Access will
group only so many before it stops grouping.

I thought the question was perfectly clear the first time. If there is a limit
(I don't think there is) then it is clearly WAY higher than 900 as my test of
grouping on a value with 32000 values clearly demonstrated.

There is something else wrong with your report. Most likely is that the query
is not returning as many rows as you think it is.

Create a temporay query like...

SELECT DISTINCT City FROM YourCurrentQueryName

....and see how many rows you get returned.