[AccessD] Top1

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 




More information about the AccessD mailing list