I have a duplicate record of payment in my DB

[SuperFreak]

Hope this is the right forum, as my question seems to encompass tables, queries and reports.

Here is what I have. I have a report, which runs off a query, which uses two tables. One table is a member master table, with member names and beginning balances, and the other is a member transaction table, with the payments that are made by the members. Each member has a number assigned to them, (not an autonumber) and the field containing those numbers are joined in the query. It works simply fine, but suddenly when I run the report or the query, I have a member who is showing up as having 2 payments, even though the transaction table only shows one. It is doubling the one payment that has been made. This only happened to two members, the others seems to be fine. I deleted the payment and re-added it, and it still seems to do the same thing. Not sure what's up with that. I have compressed the data base, still no dice. It seems like the records themselves are somehow corrupt, but since I deleted them and re-added them, I don't understand how they could continually be corrupt.

Any ideas out there?

Thanks,

Rich

 

[johngordon]

Rich,

Look to see if you have the members name listed twice in related table. This would cause two payments to show up even though you have one entry.

John

 

[AvGuy]

Set your query to show unique records only and see if this filters the spurious one. (In SQL use SELECT DISTINCT)

AvGuy

 

[SuperFreak]

How embarassing...

There WAS a double record, which I could swear I looked for, but I must have been searching the wrong table. Thanks for your assistance!!

Rich