Thanks so much for the reply. I actually figured it out after numerous attempts! I appreciate it! Doreen
eileen1309 <[EMAIL PROTECTED]> wrote: 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. > SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. [Non-text portions of this message have been removed] 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/
