Printing out multiple copy, when I only want one? 1

[schines]

When I am printing a set of forms from a selected job some how I am printing double. This only happens on selected jobs from the database. Some print out good and others print out doubles? Please Help!!

 

[dhookom]

Check your datasheet view of your report's record source. I expect there is a join where one side of the join is not unique.

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]

 

[schines]

I am not quite sure that I understand? I think that is's my falt!(sorry just started working with access and I was thrown into the database to fix the problems for work). I have a form that reads different data depending on the user chose and what Number they chose. The form prints out fine on most of the Numbers. But on two different numbers the form is printing out multiple copys and multiplying the page numbers. may-be you can help!!

 

[dhookom]

You mentioned "form is printing" but I assume you mean report. How is the reported limited based on "the user chose and what number they chose"?

Go to the design view of the report and find the Record Source property. You can view this in query design. See if the records there match your expectation.

If you can't find your problem, post your SQL view of the report's record source to this thread.

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]

 

[schines]

SQL view:

SELECT {qryECPDataFilter(Project)}.*,tblProject.Introduction,tblProjectManager
FROM tblProject INNER JOIN {qryECPDataFilter(Project)} ON tblProject.ProjectName = {qryECPDataFilter(Project)}.ProjectName;


May-be this can help!!
Thank you!

 

[dhookom]

You need to search both qryECPDataFilte(Project) and tblProject for duplicates in the ProjectName fields. Don't you have a primary key field int tblProject that would make a better candidate for joining?

BTW: I would never use ()s in the name of an object. ()s are used for functions and setting precedence in expressions.

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]

 

[schines]

Thanks that helped! For some reason the qryECPDataFilter(Project)is duplicating in this job. can't find the duplication in the table, but I will still keep looking! If you know of anything else just let me know! Thank you.

 

[dhookom]

You might remove tables from the query one at a time until the duplicates disappear.

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]

 

[schines]

Thank you very much!! I went through and found the one that was causing the duplicating, removed it and reentered the data. So far so good!! Thank you again!