G
Guest
I have duplicate report pages, how do I delete the duplicates?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Is the data source that the report is based on pulling duplicate records?
If so, fix the query that is pulling the records.
If not, give us some more details.
If so, fix the query that is pulling the records.
If not, give us some more details.
G
Guest
The report is running off a query, the query is supplying the right info..
It is boat permit software. If a person has one boat, they get one renewal
letter. If they have two boats they get one renewal letter, but with both
boats listed. The problem occurs when a person has two boats, it is printing
off duplicate copies of the same report.
It is boat permit software. If a person has one boat, they get one renewal
letter. If they have two boats they get one renewal letter, but with both
boats listed. The problem occurs when a person has two boats, it is printing
off duplicate copies of the same report.
R
Rick B
Sounds like you need to make sure that your report is based on the Person
table, not the boat table.
A sub report could be used to include each boat the person owns.
table, not the boat table.
A sub report could be used to include each boat the person owns.
G
Guest
It is a sub report that list the info. on the report page. Everything looks
good, it just prints out 2 copies.
good, it just prints out 2 copies.
R
Rick B
Two copies of the entire report? Or two pages per records, one after the
other?
other?
G
Guest
If a person has two boats, two report pages are printing out, in the report a
subreport is included listing their boats. It should only print one report.
It is printing duplicate copies of the report if they have more than one boat.
thanks for your help......
subreport is included listing their boats. It should only print one report.
It is printing duplicate copies of the report if they have more than one boat.
thanks for your help......
G
Guest
If they have 3 boats, 3 copies of the same report are printing
R
Rick B
The easiest way to do this would be to have the report based on the boats.
One record per boat.
Then GROUP AND SORT by person, then Boat.
In the person's header and footer you'd include the text of the letter. In
the detail section, you'd include the boat data.
You'd also have a forced page return in the person footer.
- Person Header -
Dear [Name]:...
This is to inform you that...the following boats are...
- Detail Section -
[BoatYear] [BoatMake] [ExpDate] etc,
- Person Footer -
Very truly yours,....
<page break>
One record per boat.
Then GROUP AND SORT by person, then Boat.
In the person's header and footer you'd include the text of the letter. In
the detail section, you'd include the boat data.
You'd also have a forced page return in the person footer.
- Person Header -
Dear [Name]:...
This is to inform you that...the following boats are...
- Detail Section -
[BoatYear] [BoatMake] [ExpDate] etc,
- Person Footer -
Very truly yours,....
<page break>
G
Guest
I have looked in my table and I have multiple entries for people with
multiple boats. In my query, in the permit number I want to create a
criteria saying no duplicate permit numbers should show up, can you tell me
what the syntax is?
multiple boats. In my query, in the permit number I want to create a
criteria saying no duplicate permit numbers should show up, can you tell me
what the syntax is?
R
Rick B
I would fix my data and get rid of the duplicates. I'd then set indexes to
prevent duplicate entries in the future.
prevent duplicate entries in the future.
G
Guest
In my query I have: Field: Perm_ID
Table: Permittee
Sort:
Show:
Criteria:
What syntax do I need to include to exclude duplicate Perm_ID numbers. I do
not want to delete them, just ignore the duplicates.
Table: Permittee
Sort:
Show:
Criteria:
What syntax do I need to include to exclude duplicate Perm_ID numbers. I do
not want to delete them, just ignore the duplicates.