Limit record in report

[DavidW]

Is there a way to limit a reports header to a specific record in a query?
I have a query that sums a table by month, also that query is sorted by a
field that has the numbers 1, 2, and 3.
If you open the query and look at the data ,there are 3 different rows of
calculated sums in that query
What I am trying to do is to take each row and put them into a different
header, so that I have got unique labels and data.
Is this possible or is there a different way to accomplish this?
Thanks
David

 

[John Vinson]

What I am trying to do is to take each row and put them into a different
header, so that I have got unique labels and data.
Is this possible or is there a different way to accomplish this?

Very easy.

Right mouseclick on the little square at the upper left intersection
of the rulers in report design view. Select "Sorting and Grouping".
Group BY the month, and specify that you want to see the group headers
and footers.