Duplicate values in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK I have a report where I will generally want to hide the duplicates, except
when it is a specific value. How would I code it so that it does not hide
dups on one value, but hides it on all others.

TIA
 
You could use a group query to remove duplicates and then union that with the
particular record, e.g.

SELECT Department
FROM tblEmployees
GROUP BY Department
UNION
ALL SELECT Department
FROM tblEmployees
WHERE Department="Tax"
ORDER BY Department;

(but please don't bite me if this isn't the answer you're looking for...)
 
Thanks, but I am looking for dups in a particular field not a whole record.
I still want all of the records to show, but on one field I only want one
particular value to duplicate.

I probably wasn't as clear as I should have been.
 
You should still be able to use your version of my query - just save it then
create another query based on it as well as the original table. Then above
the QBE gride link the two by way of the "duplicate" field. Then you can
include the other headings you want to see.
 
Back
Top