Duplicate pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smiley01 - 31 Jan 2006 15:00 GMT

I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Rick B - 31 Jan 2006 15:25 GMT

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.

Signature

Rick B

>I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 16:06 GMT

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.

> 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.
>
> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Rick B - 31 Jan 2006 16:18 GMT

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.

Signature

Rick B

> 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
[quoted text clipped - 10 lines]
>>
>> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 16:29 GMT

It is a sub report that list the info. on the report page. Everything looks
good, it just prints out 2 copies.

> Sounds like you need to make sure that your report is based on the Person
> table, not the boat table.
[quoted text clipped - 15 lines]
> >>
> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Rick B - 31 Jan 2006 16:40 GMT

Two copies of the entire report? Or two pages per records, one after the
other?

Signature

Rick B

> It is a sub report that list the info. on the report page. Everything
> looks
[quoted text clipped - 22 lines]
>> >>
>> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 16:51 GMT

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......

> Two copies of the entire report? Or two pages per records, one after the
> other?
[quoted text clipped - 25 lines]
> >> >>
> >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Rick B - 31 Jan 2006 16:59 GMT

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>

Signature

Rick B

> If a person has two boats, two report pages are printing out, in the
> report a
[quoted text clipped - 36 lines]
>> >> >>
>> >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 16:53 GMT

If they have 3 boats, 3 copies of the same report are printing

> Two copies of the entire report? Or two pages per records, one after the
> other?
[quoted text clipped - 25 lines]
> >> >>
> >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 17:32 GMT

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?

> If they have 3 boats, 3 copies of the same report are printing
>
[quoted text clipped - 27 lines]
> > >> >>
> > >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Rick B - 31 Jan 2006 17:47 GMT

I would fix my data and get rid of the duplicates. I'd then set indexes to
prevent duplicate entries in the future.

Signature

Rick B

>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
[quoted text clipped - 40 lines]
>> > >> >>
>> > >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message

Smiley01 - 31 Jan 2006 18:45 GMT

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.

> I would fix my data and get rid of the duplicates. I'd then set indexes to
> prevent duplicate entries in the future.
[quoted text clipped - 43 lines]
> >> > >> >>
> >> > >> >> >I have duplicate report pages, how do I delete the duplicates?

Reply to this Message