>Nick,
>
>You need to add that column to the group by as well as the order by
>
>

>Your query:
>SELECT Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position,;
>  ALLTRIM(Lv_pic.lastname)+", "+ALLTRIM(Lv_pic.firstname)+Lv_pic.middle;
> FROM photoid!lv_pic Lv_pic_a;
> GROUP BY Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position;
> ORDER BY Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position, 4
>
>Fixed:
>SELECT Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position, ;
>  ALLTRIM(Lv_pic.lastname)+", "+ALLTRIM(Lv_pic.firstname)+Lv_pic.middle ;
> FROM photoid!lv_pic Lv_pic_a ;
> GROUP BY Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position, 4 ;
> ORDER BY Lv_pic_a.division, Lv_pic_a.unit, Lv_pic_a.position, 4
>

Duh!!

Thanks
Nick Patel