Multiple records in a query

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

I am pulling a very simple query: anybody throughout the last 3 years who
have given a financial donation. However, I am getting Multiple/Duplicate
records showing in my query (same ID of record); it's not like i typed in
duplicates but for some reason my query is creating duplicates. CAn you
please HELP!!!

Thanks
 
Angie said:
I am pulling a very simple query: anybody throughout the last 3 years who
have given a financial donation. However, I am getting Multiple/Duplicate
records showing in my query (same ID of record); it's not like i typed in
duplicates but for some reason my query is creating duplicates. CAn you
please HELP!!!
Click to expand...


We can probably help with your query, but not much until we
see the query and an explanation of the tables and their
relevant fields.

At this point, all I can do is guess that the query is
joining two tables and the other table has multiple records
for each join field value.
 
It is very hard to review your query without you opening it in design or SQL
view for me.
Do you think you can do that?
I cannot see the table names or the fields and their datatype.

Here is a thought, why not open the query in design view, click on VIEW -
SQL View, hightlight all, copy, and paste in a post.
 
Thank you both for replying.

being that this is a big query, how is the best way of me to do this so that
you can help? you may also email me directly at
(e-mail address removed)

thank you
Angie
 
being that this is a big query, how is the best way of me to do this so that
you can help?
Click to expand...


Open the query in SQL view and post the SQL text here.
you may also email me directly at
(e-mail address removed)
Click to expand...

We're all unpaid volunteers here; most of us either have day jobs or work as
paid consultants. For me, as for many, private email support is reserved for
paying clients; free support is here on the newsgroups, so others can benefit
from seeing the problems and the answers.
 
Back
Top