[AccessD] Top1

Wouldn't 'First' work?  Do you have Addresses in a separate table, or is it
in the users table?

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com] 
Sent: Friday, January 26, 2007 9:01 AM
To: 'Access Developers discussion and problem solving';
dba-sqlserver at databaseadvisors.com
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