Report is printing several copies of each entry.

[jforozco]

My databse consists of entering Job Information for a packaging company.
The information that needs to be known for each job is:
Job Info
Board Info
Lining Info
Wrap Info
Corrugated Info
Outside Purchases info
Stampin info
etc.

All this information needs to be printed out on a report that we call a JOB BAG.
I have tables for each one of the previously mentioned categories.
I also have forms for each one of them.
all tables are connected by The JobName.
In other words the JobName is what identifies that a particular board related to a particular Job.

The way i approached this report was to use the Job Table for the Header of the report which should appear on both pages of the JOB BAG.
Then i used sub-reports to place the other infor (board,linings, wraps, corrugated, etc) on the report.

I have to major problems with it right now.
One is that it is giving me 1152 copies of each job and i am pretty sure that it is because of my SQL statement in the record source of the report.

Here is a copy.

SELECT Job.*, Board.*, Linings.*, Wraps.*, Corrugated.*, CheckList.*, [Outside Purchases].*, Stamping.*, CuttingDies.*, Blocks.*, StampDies.*
FROM StampDies INNER JOIN (Blocks INNER JOIN (CuttingDies INNER JOIN (Stamping INNER JOIN ([Outside Purchases] INNER JOIN (CheckList INNER JOIN (Corrugated INNER JOIN (Wraps INNER JOIN (Linings INNER JOIN (Job INNER JOIN Board ON Job.JobID & " " & Job.JobName=Board.JobName) ON Linings.JobName=Job.JobID & " " & Job.JobName) ON Wraps.JobName=Job.JobID & " " & Job.JobName) ON Corrugated.JobName=Job.JobID & " " & Job.JobName) ON CheckList.JobName=Job.JobID & " " & Job.JobName) ON [Outside Purchases].JobName=Job.JobID & " " & Job.JobName) ON Stamping.JobName=Job.JobID & " " & Job.JobName) ON CuttingDies.JobName=Job.JobID & " " & Job.JobName) ON Blocks.JobName=Job.JobID & " " & Job.JobName) ON StampDies.JobName=Job.JobID & " " & Job.JobName;

Another problem that i need help fixing is that It will not only show 1152 copies of each JOB BAG but it will put all of them on the same report.
So if i have 3 job bags in the database i will get 1152 x 2(pages per job bag) x 3 (job bags) pages total.

I was thinking of maybe having another a form with a drop down menu with all the jobs and have the user pick the job and the report for that job will print out.
Please help me with this.

thanks
Juan

 

[dhookom]

If you have subreports to show the related tables, remove these tables from the record source of your main report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jforozco]

I will definitely try that and hope it works. I think that might solve the fact that the report is showing several copies of the same entry, but will that solve the fact that all the entries are showing together as one large report. How do i separate the entries so they all show up in different reports, or even better how can I ask the user to enter the ID of the entry he/she wants to print the report for?

please let me know, and i thank you in advance.

jforozco

 

[dhookom]

Read through some of the tips at Martin Green's page

http://www.fontstuff.com/access/index.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jforozco]

dhookom,
What you said to try in the first post work perfectly. THANKS

Now what i am battling with is the fact that i want to print one Job Bag for each Job separatelly. In other words i want to be able to have the user pick the job they want to print the report for and have the database print the job bag(report) just for that job. Right now when i open my report it shows just the info i need but it shows the information for all jobs in the same report, so if they wanted to print the report for a particular job they would have to find the exact pages and print only those pages.
I want to avoid that and make my database a little more user friendly can you help me?
thanks
jforozco

 

[dhookom]

Did you check the link from my previous reply? If so, do you have questions?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]