New User - Linking tables
Post the SQL of the query that is returning the duplicates, please.
To do that, open the query in the query builder, select SQL view, and
copy/paste it into a reply and we will have a look.
--
Dave Hargis, Microsoft Access MVP
"sheri" wrote:
Okay, so I'm using Access 2000 and I'm not a programer so please speak in
plain english. I have a table of all donations made and a table of all
checks cut out of our program. The relationship between the tables is an ID
if applicable and in some cases a donation key. Some, but not all, donations
are related to checks and visa-versa and not all donations or checks have an
ID. I'm trying to run a report by ID that shows both the donations and
checks. I've designed a simple query to pull the information together but
the results are showing a lot of duplicate records and I'm not sure why.
Thanks in advance!
|