A report issue

  • Thread starter Thread starter Rita D via AccessMonster.com
  • Start date Start date
R

Rita D via AccessMonster.com

I'm printing a report . Currently, the information comes from a query. There
are three columns Date, rr#, and count.
I created a report and I grouped by rr#, Date Ascending.
I get this

RR#2
Oct 2004 100
Nov 2004 200
Dec 2004 300

RR#3
Sep 2004 200
Oct 2004 500
Nov 2004 300

RR#4

etc....



How can I get the information to show like this instead,

RR#2 RR#3 RR#4
RR#5 RR#6
Oct 2004 100 Sep 2004 200
Nov 2004 200 Oct 2004 500
Dec 2004 300 Nov 2004 300

Is it possible?

Thanks,

Rita
 
I think you can create narrow subreport of the dates and counts. Create a
main report with multiple columns based on a record source like:
SELECT [RR#]
FROM [a query]
GROUP BY [RR#];
Add the subreport to the detail section of the main report and set the link
master/child properties to [RR#].
 
Back
Top