Re: Oddly duplicated records in a report, based on information from a

From: Sirocco (NB2002_at_arczip.com)
Date: 12/28/04


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.



Relevant Pages

  • Re: Double click
    ... I have a form that folks use to report ... likely a duplicate, you should be able to just discard the duplicate, and ... >>> written with asp, and it submits to an asp page, and the results are ... >> the user clicks the submit button a second time, before the first request ...
    (microsoft.public.inetserver.asp.db)
  • RE: Compare workbooks
    ... origional code, which opens the new report fine, it then creates a new ... worksheet at the end of the older report. ... numbers in coloum A but these dont show up in the new work sheet. ... So I am looking for duplicate rows where coloum A is ...
    (microsoft.public.excel.misc)
  • Re: kernel BUG at mm/rmap.c:480 in 2.6.10-rc3-bk7
    ... Great you can duplicate it, useful info, thanks a lot. ... relying on a single page report seems unwise) of "Bad rmap" messages. ... static void zap_pte_range(struct mmu_gather *tlb, ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • How to create duplicate report? (Copy of report, not report of dup
    ... Okay, one would think that if you wanted to duplicate a report, you would ... Not so (because Microsoft doesn't care for intuitive design, ... I hate you Microsoft. ...
    (microsoft.public.access.reports)
  • RE: How to remove code?
    ... > Sounds like your mdb is corrupted. ... > Go to each report and form and and change the Has Module property to No. ... >> create duplicate values in the index, primary key, or relationship. ... >> the data in the field or fields that contain duplicate data, ...
    (microsoft.public.access.forms)

Loading