M
Microsoft News Server
I am working with a customer database which, unfortunately, contains some
duplicate information. Existing customers were sometimes added as new
customers. I need to create a query which will find only the most recent
record of each group of records which contain the same customer name. Any
help would be appreciated. Here is an example of what I need:
Existing Data
Name Date Other Information
Jane Smith 3/21/2004 Address, Phone, etc.
Jane Smith 7/02/2006 Address, Phone, etc.
Jane Smith 9/27/2007 Address, Phone, etc.
Jane Smith 3/19/2008 Address, Phone, etc.
John Doe 1/21/2006 Address, Phone, etc.
John Doe 3/24/2007 Address, Phone, etc.
John Doe 4/1/2008 Address, Phone, etc.
Desired Query Output
Name Date Other Information
Jane Smith 3/19/2008 Address, Phone, etc.
John Doe 4/1/2008 Address, Phone, etc.
duplicate information. Existing customers were sometimes added as new
customers. I need to create a query which will find only the most recent
record of each group of records which contain the same customer name. Any
help would be appreciated. Here is an example of what I need:
Existing Data
Name Date Other Information
Jane Smith 3/21/2004 Address, Phone, etc.
Jane Smith 7/02/2006 Address, Phone, etc.
Jane Smith 9/27/2007 Address, Phone, etc.
Jane Smith 3/19/2008 Address, Phone, etc.
John Doe 1/21/2006 Address, Phone, etc.
John Doe 3/24/2007 Address, Phone, etc.
John Doe 4/1/2008 Address, Phone, etc.
Desired Query Output
Name Date Other Information
Jane Smith 3/19/2008 Address, Phone, etc.
John Doe 4/1/2008 Address, Phone, etc.