Gustav Brock
Gustav at cactus.dk
Fri Jan 26 09:22:21 CST 2007
Hi John How about using First for the name and Group By for the address? /gustav >>> jwcolby at colbyconsulting.com 26-01-2007 16:01:06 >>> 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