Query gives correct result set while the report does not

[Guest]

This happens when there are multiple subgrants. A sample query output could
be described as:
SubgrantId LineNumber Comments Year
x1 1 Furnish document
04
x1 2 Do total
04
x1 3 Keep detail
04
x2 1 Subtract
04
x2 2 Keep detail
04
x2 3 Multiply
04
x2 4 Keep comments
04

The output should look like this:
Subgrant X
...................................................................................................................
LineNumber Comments
1 Furnish document
2 Do total
3 Keep detail
...................................................................................................................
Signature Title

Next Page:
Subgrant X
...................................................................................................................
LineNumber Comments
1 Subtract
2 Keep detail
3 Multiply
4 Keep comments
..................................................................................................................
Signature Title


Now, I am doing sorting and grouping by first subgrantid and then by
linenumber, both being ascending.
The details of grouping for both the groups are as below:

GroupHeader No
GroupFooter No
Group On Each Value
Group Interval 1
Keep Together No

With this setting the results are not coming as desired. Any help is
appreciated, as to where I am going wrong. Thanks.

 

[Larry Linson]

You need to group by Subgrant ID, but only sort by Line number. What I think
you specified would mean that each combination of SubgrantID and LineNumber
would be a separate Group.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for your help, I will try to implement as per your advise.