I would base you sub report on a different query and then tie the two report together based on a unique id such as RepID. this way your main report reflects on the Rep and the sub-report represents all of his/her accounts.
--- In [email protected], "rokkeee" <[EMAIL PROTECTED]> wrote: > > I have created a Main report with one Subreport both linked to the > same query. Each Rep has several accounts. I have the RepID and other > necessary fields appearing on the Main form just fine along with the > multiple accounts' details listed below in the sub-report. When I view > the report and scroll through the pages, I'm seeing the same > information listed in the subreport for as many times as the rep has > accounts. I hope you can understand this and help me get only ONE page > per RepID with the multiple accounts listed. > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
