Re: How do I find duplicates in Access 2002 without the install cd-rom

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 12:00:18 -0600

Next time please provide more information about your table structure.
Generically, create a query like:
SELECT ContactName, Count(*) as NumOf
FROM tblContacts
GROUP BY ContactName
HAVING Count(*) >1; 

-- 
Duane Hookom
MS Access MVP
"NYDCC" <NYDCC@discussions.microsoft.com> wrote in message
news:E96D3B98-C46A-455B-9AFF-77D45D7B232F@microsoft.com...
> Does anybody know how to find duplicate contacts in Access 2002 without
the
> feature installed, and without the cd-rom?

Relevant Pages

  • Re: Help With SELECT Statement
    ... SELECT ContactName, SUM ... FROM tblContacts RIGHT JOIN tblInvoices ON tblContacts.ContactID = ... SumAS SumAmount ...
    (microsoft.public.sqlserver)
  • Re: Help With SELECT Statement
    ... > SELECT ContactName, SUM ... > FROM tblContacts RIGHT JOIN tblInvoices ON tblContacts.ContactID = ... > SumAS SumAmount ...
    (microsoft.public.sqlserver)
  • Re: concatenating fields in an SQL query
    ... > get a nieuw field ContactName to select in dropdownbox. ... > If one of the 3 fields is empty i get an empty ContactName string back. ... > tblContacts.*, ...
    (borland.public.delphi.database.ado)
  • concatenating fields in an SQL query
    ... I'm trying to concatenate 3 fields: FirstName + MiddleName + LastName to get ... If one of the 3 fields is empty i get an empty ContactName string back. ... FROM tblContacts ... MiddleName, Text 10, Required = No, Allow Zero Length = Yes ...
    (borland.public.delphi.database.ado)