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