duplicate data on a report

B

bdboynton

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
 
D

Duane Hookom

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.
 
B

bdboynton

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?
 
Top