Access Reports

G

Guest

I have reports printing as form letters. Right now I have separate reports
to list the main letter and one to list the equipment. I combined them into
1 letter but now instead of listing the equipment on one page again, it
breaks it out into 1 page per piece of equipment. How can I combine them so
that all equipment is on 1 page again?

Thank you very much!
 
P

Pat Hartman \(MVP\)

Use a subreport for the equipment. Don't forget to remove the equipment
table from the main report's recordsource or you'll get duplicate pages.
 
G

Guest

Thanks Pat. I was able to get the subreport in but now it is asking me for
parameters each time I want to scroll to the next page. There are blank
pages and the first page repeats several times. A 2 page letter becomes 66
pages. What am I doing wrong?

Thank you!!
 

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