Duplicating Reports

[dan.cawthorne]

Hi all, I Was wondering if some one could tell me where im going
wrong,

i have a report which has 2 Subforms on it.

the main report shows the Project Tittle and Enquiry Item.

The first sub form shows the related drawings that are sent with that
enquiry.

and the second sub form shows which company's the enquiry was issued
to.

The Problem im having is if i assigned the enquiry to 5 companys then
the report would be 5 pages long, showing 5 identical pages one for
each company. so what im having to do when i print it the report is
having to remember to print pages 1 of 1

taking for second subform off doesn't prevent this as they are still
assigned to the enquiry.

any help or suggestions.?

Regards

Dan

 

[Marshall Barton]

Hi all, I Was wondering if some one could tell me where im going
wrong,

i have a report which has 2 Subforms on it.

the main report shows the Project Tittle and Enquiry Item.

The first sub form shows the related drawings that are sent with that
enquiry.

and the second sub form shows which company's the enquiry was issued
to.

The Problem im having is if i assigned the enquiry to 5 companys then
the report would be 5 pages long, showing 5 identical pages one for
each company. so what im having to do when i print it the report is
having to remember to print pages 1 of 1

taking for second subform off doesn't prevent this as they are still
assigned to the enquiry.

I hope you are using subreports, not subforms.

The problem sounds like your main report's record source has
a join to the customers table.

 

[dan.cawthorne]

I hope you are using subreports, not subforms.

The problem sounds like your main report's record source has
a join to the customers table.

Marshall I ment Sub Reports.

the Reports Record Source is Qry_DrawingIssueSheet and the Query is
based on 3 Tables With Relationships

First table is tblEnquiry
Second table is tblEnquirySupplierLink
and First table a Few Fields from tblSuppliers

The reason why i used the tblsuppliers was so i can create a mail
merge to work creating a letter with company details.

 

[Marshall Barton]

Marshall I ment Sub Reports.

the Reports Record Source is Qry_DrawingIssueSheet and the Query is
based on 3 Tables With Relationships

First table is tblEnquiry
Second table is tblEnquirySupplierLink
and First table a Few Fields from tblSuppliers

The reason why i used the tblsuppliers was so i can create a mail
merge to work creating a letter with company details.

Test the query all by itself. I think you will see that is
the cause of the problem in the report.

If that's true, then try basing the main report on the one
table or a different query that only returns the records
required by the report.