Allen Brown's Flexible search-How do get rid of duplicates?

  • Thread starter Thread starter joann007
  • Start date Start date
J

joann007

Hello all! I've created a flexible search like the one described by
Allen Browne at http://allenbrowne.com/ser-62.html. It works great,
except that it shows duplicates records as results. I know why this
happens: I have a one-to-many relationship between my Master table
and
by DocAnalysts and DocTaxes tables. Since each record can have more
than one analyst or tax type, it's showing up multiple times as a
result of the search. Is there any way I can fix this?

The form itself is based on a query that links all three tables by
DocID. I've played around with the unique values/unique records
property with no luck. Allen, if you are out there, help me please!


Thanks guys!
 
Im not familiar with Alans solution but can you amend the query to look as
follows:
SELECT DISTINCT etc.

This will result in unique rows only
 
Back
Top