Multiple instances of same record returned

  • Thread starter Thread starter S.
  • Start date Start date
S

S.

I am trying to run a query from multiple tables, and I
finally got that to work, but now it's returning multiple
instances of the same record.

I don't understand all the technical language I'm reading
on here, so in simple terms here it is:

We have a database of our filing system. I'd like to set
up a query that will search by client name and bring up
instances of files associated with that client in the
various places - one place at a time, that is. I've
joined together our client list and job list tables in one
query, and then used that in this new query. When I run
the query, a parameter comes up that lets me type in the
client name I'm searching for. Rather than bringing me
one instance of each file in our filing cabinets, it will
bring me three instances of one file, six instances of
another, etc. I want only one instance to come up.

Does this make any sense to anyone?

-S.
 
Not really understanding either your table structure nor your query, this is
only a guess...

Open the query in design mode. Right-click in the open grey space in the
upper window and select Properties. Set the Unique Values property to
"Yes".

You should get one copy of each, no matter how many rows match your query
criteria (which, by the way, is the reason you are getting multiples).

NOTE: you will NOT be able to edit/update the results of the query, since
it is a kind of "summary" query (one line, no matter how many actually
match), and Access would have no way to know which original should be
changed.

Good luck

Jeff Boyce
<Access MVP>
 
That fixed it - thanks! It doesn't need to be updated
here because the entire database is set up to allow others
to search what's there ONLY, not make any changes. The
changes are all made in a separate database, to which this
one is linked.

Thanks for your help!

-S.
 
Back
Top