Re: Oddly duplicated records in a report, based on information from a
From: Sirocco (NB2002_at_arczip.com)
Date: 12/28/04
- Next message: Pierre Faubert via AccessMonster.com: "label printing"
- Previous message: Pat Z.: "Count Records in a Group 2nd Request"
- In reply to: dhender09: "Oddly duplicated records in a report, based on information from a"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Dec 2004 14:37:02 -0500
Are the records actually duplicated, or do some records grouped together
have the same information, where just certain colummns repeat? If you're
actually getting duplicate records, in the underlying query, set the Unique
Records property to Yes. You might also want to experiment with the Unique
Values property.
"dhender09" <dhender09@discussions.microsoft.com> wrote in message
news:95298835-088D-4444-B6D5-6351222E7BD7@microsoft.com...
> Hi, got one question answered today, which I thought would solve all of my
> problems, but unfortunately not.
>
> Basically, I have created a report based on a table, which has links to
> other tables, when run the report duplicates certain records and I am not
> sure
> why. These links have not changed and in past iterations of the report,
> there were no duplication issues. The only thing of note that has been
> modified is the version of Access from 2000 to 2002.
>
> If anyone has a reasonable explanation for why a report would be
duplicating
> records from a table I will appreciate hearing it.
- Next message: Pierre Faubert via AccessMonster.com: "label printing"
- Previous message: Pat Z.: "Count Records in a Group 2nd Request"
- In reply to: dhender09: "Oddly duplicated records in a report, based on information from a"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|