one record in database prints twice on report

[Guest]

My Access database has 277 records. When I print one report (other 10 reports
are OK), one record prints twice on the report. I added a field to the
report to display the recordID in case it was somehow duplicated on the
database - same ID number.
I deleted and re-added the record: still prints twice, with new recordID.
Any hints on what to look for?
Thanks for your help.

 

[Duncan Bachen]

My Access database has 277 records. When I print one report (other 10 reports
are OK), one record prints twice on the report. I added a field to the
report to display the recordID in case it was somehow duplicated on the
database - same ID number.
I deleted and re-added the record: still prints twice, with new recordID.
Any hints on what to look for?
Thanks for your help.

Is the recordsource of the report a table or a query? If it's a query,
is it a single table query, or one with joins?

There's a chance that the underlying query (depending on how the joins
are setup), could return the same record more than once.

 

[Guest]

Most of my information is in 1 table (Hardware), only go to ProjManager table
for full name of manager. The query (in Properties / Record Source) is:

SELECT Hardware.AssetType, Hardware.DateOOS, Hardware.ID, Hardware.ProjMan,
ProjectManagers.FullName, ProjectManagers.Extension, Hardware.MachineName,
Hardware.IPReal, Hardware.GovtTagNo, Hardware.ManufTagNo, Hardware.Manuf,
Hardware.Model, Hardware.OS, Hardware.ServerFunction, Hardware.MajorApps,
Hardware.SysAdmin1, Hardware.SysAdmin2
FROM Hardware INNER JOIN ProjectManagers ON Hardware.ProjMan =
ProjectManagers.LastName
WHERE (((Hardware.AssetType)="SERVER") AND ((Hardware.DateOOS) Is Null) AND
((Hardware.IPReal)="R"));

I'm new to Access and report so nothing is too complicated, just pull the
fields I need, get the full name and only pull records that meet the 3
conditions. Can't get much simplier. But no matter what I do, it still
prints 2 entries for 1 record -- none of the others are duplicated, only this
one. I deleted it and re-entered it in case there was some garbage in one of
the fields but same results.

Thanks for you help.

 

[Duane Hookom]

I would recommend NOT joining on a LastName value. You probably have two
records in ProjectManagers with the same last name. You should be linking
with Primary and Foreign key fields.

 

[Guest]

THANK YOU !! You put me on the right track. There was a duplicate record in
the ProjectManagers table. The report now prints correctly.

Thanks to both of you for your help.