Check your Link Child field property and the Link Master field property of the SubReport. Since the query is working fine, I suspect that the linking fields are not connecting properly. Typically the primary key fields are listed.
Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of bassfolks Sent: Monday, January 09, 2006 4:28 PM To: [email protected] Subject: [AccessDevelopers] Re: Help with Report --- In [email protected], Jose Luis Mora Jr <[EMAIL PROTECTED]> wrote: > > Debbie, > > To eliminate the duplicates in your report, you need to go to the query the report is using and enable the Totals option from the View dropdown menu. This should only display the unique records in your query and then your report should be fine. > > Hope this helps. > > Jose > Thanks for helping, Jose. I tried what you suggested, but that didn't do it -- still duplicated in the report. The information isn't duplicating in the query, just the report. The report contains the primary information and the subreport contains the related records. If the subreport contains seven related records, then that entire group appears in the report seven times. If the report is not connected to a query, it's fine. Any ideas? Debbie Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
