Can't get rid of duplicates in an Access sub report -

i'm having issue report containing subreport in access 2007. let me preface saying didn't create database, in place , i've kinda been put in position of taking over, , don't know access.

basically need report pull customer history , payment history, group them based on phone number, display history below, , being sorted received date.

what happening though i'm getting duplicates of payment info.

here's being output:

555-1212 john smith 123 whatever dr hometown, usa 90210  sold date   received date   amount   agentname 1/1/2013       1/4/2013       50       jack 6/1/2012       6/6/2012       25       jim  sold date   received date   amount   agentname 1/1/2013       1/4/2013       50       jack 6/1/2012       6/6/2012       25       jim 

so can see, grouping sales correctly on phone number, shown phone number, name, , address being displayed once. each instance subreport pulls, shows info again. need 1 set of sale information display per customer.

i have 2 tables, 2 queries, , 2 reports doing of this.

one table contains customer information, other contains sale information.

the queries pull needed info.

my main report has phone number, name, , address inside header section. set group on phone number, , keep group on 1 page.

my subreport contains sale info inside detail section. set sort received date.

i've tried ton of combinations of grouping, sorting, , moving subreport in , out of header , detail sections no avail. 1 way or there's duplicates , can't figure out how sort whole shebang received date when said , done. appreciated!

create phone number group section , move top line phone number, name, , address , sales information subreport inside new group header. then, minimize detail section.

from example, john smith has 2 sales info records. therefore, sub report placed in detail section repeat twice 2 appearances in main report. recall item in detail section repeat number in recordsource. yet positioning items in distinct group section remove duplication.