Limit record in report

  • Thread starter Thread starter DavidW
  • Start date Start date
D

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
 
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?
Click to expand...

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.
 
Back
Top