duplicate data on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access 2000 and am taking over an existing program. It is for a
fire department database. When I attempt to print out a report that tells me
what firemen are due to have their memberships renewed, I get duplicate
information about each firemen(exactly the same information on the very next
line). How do I eliminate this second line. Is the report looking at the
database twice or could the database be on my computer twice and the report
picking it up twice. What should I look for? Any help would really be
appreciated. I don't know where to go for this assistance. Thank you very
much in advance. Bruce
 
Open the report in design view and find the Record Source property. Open the
builder for this property which displays a query window. Change the view to
Datasheet view and see if there are duplicate records in the query.
 
no exact duplicate records were found, however I did find two that were
similar with one word differnt one had (FDconcitystatezip) the other had
(FDcitystatezip) both in Qry experation month. Would this cause the problem?
 
Back
Top