report - Group & Sort function MS Access 2010 returning only first row -

i having issue ms access 2010 when creating report query have.

i cannot share of code or print due copyright concerns, try describe problem simple can.

i have query returns data populating report. let's say, data returned:

 group   creationdate   price 1       11/05/2010     $3.55  1       01/07/2011     $0.9 2       01/01/2011     $1.00 2       09/19/2014     $9.05 2       07/30/2006     $6.99 3       03/22/2011     $4.56 3       05/21/2008     $5.23 

i grouped "group" , expected have:

 group creationdate   price 1                11/05/2010     $3.55          01/07/2011     $0.9 2           01/01/2011     $1.00         09/19/2014     $9.05         07/30/2006     $6.99 3         03/22/2011     $4.56         05/21/2008     $5.23 

what have instead is:

group   creationdate   price 1                11/05/2010     $3.55          11/05/2010     $3.55  2           01/01/2011     $1.00         01/01/2011     $1.00         01/01/2011     $1.00 3         03/22/2011     $4.56         03/22/2011     $4.56 

ms access repeating first row every group. idea on may causing this??

the query report this:

select allinfo.* (select i.id, i.[number], iif( i.projecttype = 'type1', p.code,     fp.code) code, ic.[comment], ic.[date] commentdate tbproj p right join ((tbitems left join tbfprojects fp on i.projectid = fp.id) left join tbitemscomm ic on ic.itemid = i.id) on i.projectid = p.id group i.id, i.[number], i.dateopened, ic.comment, p.code, fp.code)  allinfo; 

the grouping in report (visually using access group & sort tool) it:

 sort code     group on number           sort commentdate 

thanks help.