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
