A report issue

  • Thread starter Rita D via AccessMonster.com
  • 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
 
D

Duane Hookom

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#].
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top