Duplicate entries on report (not in table)

[Tom via AccessMonster.com]

I have a report based on a query and a table; data is entered to the table
via a form. The table has the information (autoID, first, last name, hours
worked) displayed correctly (as entered), but when I view the report, 2 of
the entries (belonging to the same person) are listed twice, ie "John Smith
8hrs" is listed on two rows, and "John Smith 16.3 hours" also listed on two
rows. This, despite the data only listed once each in the table. Any help
is greatly appreciated; I'm new to this beast.

Thank you

 

[Duane Hookom]

Reports don't generate new records. Open the record source of report and
view its datasheet view to see if there are duplicates.

 

[Tom via AccessMonster.com]

Thanks for the suggestion. I checked it out--there are not duplicates in the
table (source for report).

Tom

Reports don't generate new records. Open the record source of report and
view its datasheet view to see if there are duplicates.

I have a report based on a query and a table; data is entered to the table
via a form. The table has the information (autoID, first, last name,

[quoted text clipped - 9 lines]

Thank you

 

[Duane Hookom]

Do you have two John Smiths? I think the issue is in your data, not the
report.

--
Duane Hookom
MS Access MVP
--

Thanks for the suggestion. I checked it out--there are not duplicates in
the
table (source for report).

Tom

Reports don't generate new records. Open the record source of report and
view its datasheet view to see if there are duplicates.

I have a report based on a query and a table; data is entered to the
table
via a form. The table has the information (autoID, first, last name,

[quoted text clipped - 9 lines]

Thank you

 

[Tom via AccessMonster.com]

Thanks for your help. I have one John Smith who works two places (ie has two
entries in one table "tblUnits"), who has one unique ID; each table entry has
a unique ID also. For some reason though, when I run the report, it lists
his name 4 times (twice each for each table entry mentioned above).

Do you have two John Smiths? I think the issue is in your data, not the
report.

Thanks for the suggestion. I checked it out--there are not duplicates in
the

[quoted text clipped - 11 lines]

 

[Duane Hookom]

I still think you have issues in your report's record source. You first
stated "table (source for report)" yet I assume the record source of your
report is not a single table.

Can you describe your table structure and provide the SQL view of your
report's record source?

--
Duane Hookom
MS Access MVP

Thanks for your help. I have one John Smith who works two places (ie has
two
entries in one table "tblUnits"), who has one unique ID; each table entry
has
a unique ID also. For some reason though, when I run the report, it lists
his name 4 times (twice each for each table entry mentioned above).

Do you have two John Smiths? I think the issue is in your data, not the
report.

Thanks for the suggestion. I checked it out--there are not duplicates
in
the

[quoted text clipped - 11 lines]

Thank you

 

[Tom via AccessMonster.com]

Thanks again. My tables:

tblDailyUnits
tblEmployees
tblHoursWorked

qryBilledUnits (sums daily units for the week)
qryUnitsPerHour (which takes sum of units and divides by hours worked)

rptProductivity (record source: SELECT tblEmployees.ID, tblEmployees.
FirstName, tblEmployees.LastName, tblHoursWorked.WeekEndingDate,
qryUnitsperHour.SumOfBilledUnits, qryUnitsperHour.HoursWorked,
qryUnitsperHour.UnitsPerHour FROM (tblEmployees INNER JOIN qryUnitsperHour ON
tblEmployees.ID=qryUnitsperHour.EmployeeID) INNER JOIN tblHoursWorked ON
tblEmployees.ID=tblHoursWorked.EmployeeID;

Not much of that source makes sense to me, but I'm quite new to access. If
it looks like something you want to tackle, more power to you. And thanks.
(Is that the SQL you asked for? If not, I'm not sure how to get that.)

I still think you have issues in your report's record source. You first
stated "table (source for report)" yet I assume the record source of your
report is not a single table.

Can you describe your table structure and provide the SQL view of your
report's record source?

Thanks for your help. I have one John Smith who works two places (ie has
two

[quoted text clipped - 12 lines]

 

[Duane Hookom]

Are EmployeeID values all unique in qryUnitsperHour?

--
Duane Hookom
MS Access MVP

Thanks again. My tables:

tblDailyUnits
tblEmployees
tblHoursWorked

qryBilledUnits (sums daily units for the week)
qryUnitsPerHour (which takes sum of units and divides by hours worked)

rptProductivity (record source: SELECT tblEmployees.ID, tblEmployees.
FirstName, tblEmployees.LastName, tblHoursWorked.WeekEndingDate,
qryUnitsperHour.SumOfBilledUnits, qryUnitsperHour.HoursWorked,
qryUnitsperHour.UnitsPerHour FROM (tblEmployees INNER JOIN qryUnitsperHour
ON
tblEmployees.ID=qryUnitsperHour.EmployeeID) INNER JOIN tblHoursWorked ON
tblEmployees.ID=tblHoursWorked.EmployeeID;

Not much of that source makes sense to me, but I'm quite new to access.
If
it looks like something you want to tackle, more power to you. And
thanks.
(Is that the SQL you asked for? If not, I'm not sure how to get that.)

I still think you have issues in your report's record source. You first
stated "table (source for report)" yet I assume the record source of your
report is not a single table.

Can you describe your table structure and provide the SQL view of your
report's record source?

Thanks for your help. I have one John Smith who works two places (ie
has
two

[quoted text clipped - 12 lines]

Thank you

 

[Tom via AccessMonster.com]

No, John is listed 2x (one with hours worked from each of 2 places).

Are EmployeeID values all unique in qryUnitsperHour?

Thanks again. My tables:

[quoted text clipped - 32 lines]

 

[Duane Hookom]

The way your joins are set up, this is the cause. You may need to use a
subreport or two to keep your data from repeating.

--
Duane Hookom
MS Access MVP

No, John is listed 2x (one with hours worked from each of 2 places).

Are EmployeeID values all unique in qryUnitsperHour?

Thanks again. My tables:

[quoted text clipped - 32 lines]

Thank you