[AccessD] Top1

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


More information about the AccessD mailing list