>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!!