View Single Post
  #5 (permalink)  
Old January 10th, 2005, 04:25 PM
elansolutionsltd elansolutionsltd is offline
Authorized User
 
Join Date: Jul 2004
Location: clapton-in-gordano, n.somerset, United Kingdom.
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default

Without knowing the table you are putting the query on, I seems to me that you simply want the First of the [SocialID] Field. Rather than choosing GroupBy select First instead. This does mean that you MUST sort your underlying table by SocialID.

Alan T