paul.hartland at fsmail.net
paul.hartland at fsmail.net
Fri Jan 26 09:14:47 CST 2007
John, Could you use something like this, off top of head so not sure..... SELECT DISTINCTROW TOP 1 [YourTable].[Name], [YourTable].[Address] FROM [YourTable] GROUP BY [YourTbale].[Name], [YourTable].[Address] Message Received: Jan 26 2007, 03:03 PM From: "JWColby" To: "'Access Developers discussion and problem solving'" , dba-sqlserver at databaseadvisors.com Cc: Subject: [AccessD] Top1 I have a dataset where I have multiple addresses, multiple people living at the same address. "Address" is defined as "Address1,zip5,zip4". Is it possible to directly create a result set with just the first record at each address? John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Paul Hartland paul.hartland at fsmail.net 07730 523179