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

From: dhender09 (dhender09_at_discussions.microsoft.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 14:05:03 -0800

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: Sequential number
    ... duplicates in a multiuser environment. ... additional proctection from duplicates. ... I would create a table with an AutoNumber ... mulitple users can generate these part numbers for the same report, ...
    (microsoft.public.access.queries)
  • RE: Comparing two columns
    ... - exactly what does "the report" mean? ... The end result would be if Column D has any duplicates in Column J, ... cell in column D to report duplicates in the other columns via ... in first cell in K: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Vlookup from multiple workbooks
    ... Q2 - your suggestions of adjusting the table range where you have duplicates ... where vlookup_1 and vlookup_2 are your VLOOKUP formulae looking at ... data is not found on one report automatically check a second report for the ... one report will have a list of employees with their empnumber ...
    (microsoft.public.excel.misc)
  • Re: SQL stored procedure returns duplicates
    ... order to report from two databases and to enable parameters. ... Let's say we have three different tables - Event, Food, Equipment. ... table as duplicates. ...
    (comp.databases.ms-sqlserver)
  • Re: Counting Minus Duplicates
    ... I have LastName, Gender, DateConfined ... My report needs to let me know that there are ... Some How I need to group the gender and hide duplicates of last name and ... > Running Sum: Over Report ...
    (microsoft.public.access.reports)